From: | Aarni Ruuhimäki <aarni(at)kymi(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: dateformat issue |
Date: | 2008-04-10 06:17:33 |
Message-ID: | 200804100917.33729.aarni@kymi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 for
the conversion ?
#DateFormat(form.date, "YYYY-MM-DD")# ? Or perhaps a custom function /
conversion script ?
Which client (browser?) / platform produces the error ?
And just out of general interest, which cf-version and platform are you
using ? Pg version ?
I use pg 8.x's on CentOS and Fedora with CF 5 Pro Linux and CFMX7 Standard. I
also heard that CFMX7+ would install and run ok on Ubuntu.
Best regards,
--
Aarni Ruuhimäki
---
Burglars usually come in through your windows.
---
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin 'Beau' Baumanis | 2008-04-10 06:41:29 | Re: dateformat issue |
Previous Message | Gavin 'Beau' Baumanis | 2008-04-10 00:14:41 | dateformat issue |