From: Stephen Davies <scldad@sdc.com.au>
To: Byron Nikolaidis <byronn@insightdist.com>
Cc: pgsql-interfaces@postgreSQL.org <pgsql-interfaces@postgreSQL.org>
Subject: ODBC: dates (again) and passthrough
Date: Fri, 01 May 1998 14:39:21 +0930
Message-ID: <199805010509.OAA09526@mustang.sdc.com.au> (raw)
G'day Byron.
I have just been modifying one of my VB5/ODBC 6.30.10/PostgreSQL 6.3.2 apps
and ran into a couple of funnies.
I thought that you had said that the default date format was now US so I
changed my code to say the following:
insert into quote (id,qdate,price) values (12,'05/01/1998',123)
(that is, I reversed dd/mm/yyyy to mm/dd/yyyy) and what arrived in the
database was Jan 5, 1998. I switched it back and got the correct result.
My postmaster is running in default US mode and I have removed the registry
entry that I had before.
Also, my app originally used the DB.Execute S$,passthrough option.
This worked with the old driver but fails with an "Out of memory" error with
your driver. Removing the passthrough option fixes the app.
Cheers and thanks,
Stephen.
========================================================================
Stephen Davies Consulting scldad@sdc.com.au
Adelaide, South Australia. Voice: 61-8-82728863
Computing & Network solutions. Fax: 61-8-82741015
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-interfaces@postgresql.org
Cc: scldad@sdc.com.au, byronn@insightdist.com
Subject: Re: ODBC: dates (again) and passthrough
In-Reply-To: <199805010509.OAA09526@mustang.sdc.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