Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql/Cold Fusion cfinsert date problems - Mailing list pgsql-odbc

From Paul Haddon
Subject Re: Postgresql/Cold Fusion cfinsert date problems
Date
Msg-id 20010704123109.A16672@mail.hartingdale.com.au
Whole thread Raw
In response to RE: Postgresql/Cold Fusion cfinsert date problems  (Jeff Eckermann <jeckermann@verio.net>)
List pgsql-odbc
Tree view 
On Tue, Jul 03, 2001 at 09:20:30AM -0500, Jeff Eckermann wrote:

> Is this a formatting issue, or are you actually getting different dates from
> the ones that you are entering?

I've tried using the date format functions of CF, and I've tried creating
strings such as '2001-02-17'. Nothing makes a difference.

Looking at the ODBC log, specified in the ODBC data source, shows that
the ODBC driver is passing Postgresql the string 'YYYY-MM-DD', with the
numbers being that of todays date.

> 2. Your cold fusion app is doing it.

Possibly. I'll try and check it through the CF support areas.

Thanks

Paul Haddon
Technical Services Manager
Hartingdale Internet

pgsql-odbc by date:

Previous
From: BELLON Michel
Date:
Subject: odbc with MS-Query
Next
From: DI Hasenöhrl
Date:
Subject: How to develope an error-handler for a kind of replication