DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding;
	b=ApxWHhtsreaegbPCS7LxYoQ5YfD+8+B5qfyEC1n0mJjOGv42GOzeuMRqMwIhH6J5AT7BQwtHJqD6B17Gr/ObVdnr+srEiU1Mi4AxyIl9rjHaphC/vhpbgFcKomapWlPe9hhN+MR9w8CvuGARduYKcsiRXUhOFbtEDRmQr6yqWFA=
Message-ID: <47FDF7CE.3090909@gmail.com>
Date: Thu, 10 Apr 2008 13:19:42 +0200
From: Tk421 <vrobador@gmail.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
CC: pgsql-sql@postgresql.org
Subject: Re: dateformat issue
References: <8817FD2B-5B01-4E3D-9C6D-A6FF165561FB@eclinic.com.au>
In-Reply-To: <8817FD2B-5B01-4E3D-9C6D-A6FF165561FB@eclinic.com.au>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Gavin 'Beau' Baumanis escribió:
> Hi Everyone,
>
> I have a question about dates, please.
>
> I am using Coldfusion and Postgres
> I have a function that takes the ate entered in a form and converts it 
> into an odbc date format.
>
> So the string ends up being;
> {d '2008-04-10'}
>
> Strangely, the function is used throughout the application and causes 
> no issues but on one particular template.
> And this same templates is replicated for other clients - that 
> seemingly have no issue .
>
>
> The SQL is simply
>
> Insert into table (datefield) values ({d '2008-04-10'})
>
> Now, I have read the docs and do not see the {d '2008-04-10'} format 
> as being a valid date data type...
> But it works elsewhere in the application / on other sites - thus my 
> current state of confusion.
>
> Thanks in advance for any ideas you might have.
>
>
>
> Please contact me if you should have any questions.
>
> Gavin 'Beau' Baumanis
> Senior Application Developer
> PalCare Pty. Ltd.
>
> E: beau@palcare.com.au
> T: +61 -3 9318 4567
> M: +61 -4 38 545 586
> W: http://www.palcare.com.au
>
    I had some similar probles with dates, and i solved it using a 
string format (yyyymmdd) to set date format, and two functions (toString 
and toDate) made by myself inf the necesary language (asp, php, jsp....)

    This format is full valid for comparations (>, <, =) and orders in 
SQL. The only problem is to work in your application, but it may be 
solved with some functions