From: Aarni =?iso-8859-1?q?Ruuhim=E4ki?= <aarni@kymi.com>
Reply-To: aarni@kymi.com
Organization: KYMI.com
To: pgsql-sql@postgresql.org
Subject: Re: dateformat issue
Date: Thu, 10 Apr 2008 09:17:33 +0300
User-Agent: KMail/1.6.2
References: <8817FD2B-5B01-4E3D-9C6D-A6FF165561FB@eclinic.com.au>
In-Reply-To: <8817FD2B-5B01-4E3D-9C6D-A6FF165561FB@eclinic.com.au>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <200804100917.33729.aarni@kymi.com>

On Thursday 10 April 2008 03:14, Gavin 'Beau' Baumanis wrote:
> 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'})
>

Hi,

The above is not a valid value for a date field. What function do you use f=
or=20
the conversion ?=20

#DateFormat(form.date, "YYYY-MM-DD")# ? Or perhaps a custom function /=20
conversion script ?

Which client (browser?) / platform produces the error ?

And just out of general interest, which cf-version and platform are you=20
using ? Pg version ?

I use pg 8.x's on CentOS and Fedora with CF 5 Pro Linux and CFMX7 Standard.=
 I=20
also heard that CFMX7+ would install and run ok on Ubuntu.

Best regards,

=2D-=20
Aarni Ruuhim=E4ki
=2D--
Burglars usually come in through your windows.
=2D--