Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] ODBC DATE PROBLEM

From: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
To: Pierluigi <pgsql(at)sif(dot)it>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] ODBC DATE PROBLEM
Date: 1998-08-06 03:05:00
Message-ID: 199808060305.MAA13230@mustang.sdc.com.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
I am not sure about Access but I use ODBC from Excel and VB.

I leave my backend in default date mode (US private format) but rely on the 
ODBC driver to switch itself to ISO format (as I recall, this approach was 
decided by consensus a few months back).

In VB, this seems to be converted to whatever I select in the Control Panel 
Regional Settings.

Sometimes I also use the VB Format function to manipulate the raw input format.

HTH,
Stephen.


========================================================================
Stephen Davies Consulting	    		                            scldad(at)sdc(dot)com(dot)au
Adelaide, South Australia.     			                            Voice: 61-8-82728863
Computing & Network solutions.	 	                            Fax: 61-8-82741015



pgsql-interfaces by date

Next:From: Bruce MomjianDate: 1998-08-06 03:53:58
Subject: Large objects names
Previous:From: Matthew HagertyDate: 1998-08-06 01:29:26
Subject: Re: [INTERFACES] postgresODBC and Symantec dbAnywhere/Visual Cafe, broken?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group