From: Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
To: aarni@kymi.com
Cc: pgsql-sql@postgresql.org
Subject: Re: dateformat issue
Date: Thu, 10 Apr 2008 16:41:29 +1000
Message-ID: <BC2EE6A2-266A-453D-957B-3C7482CEBCF4@eclinic.com.au> (raw)
In-Reply-To: <200804100917.33729.aarni@kymi.com>
References: <8817FD2B-5B01-4E3D-9C6D-A6FF165561FB@eclinic.com.au>
<200804100917.33729.aarni@kymi.com>
Hi Aarni,
just so you know I am using the CF built-in function,
createodbcdate
here is the info from livedocs.
CreateODBCDate
Description
Returns a date in ODBC date format.
Category
Date and time functions
Syntax
CreateODBCDate(date)
so I pass in 2008-01-23
and I get back
{d '2008-01-23'}
The weirdness for me is that it works elsewhere in the application, I
am really stumped.
-Gavin.
On 10/04/2008, at 4:17 PM, Aarni Ruuhimäki wrote:
> 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.
> ---
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gavinb@eclinic.com.au, aarni@kymi.com
Subject: Re: dateformat issue
In-Reply-To: <BC2EE6A2-266A-453D-957B-3C7482CEBCF4@eclinic.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox