Received: from mustang.sdc.com.au (mustang.sdc.com.au [203.2.199.1]) by
	hub.org (8.8.8/8.7.5) with ESMTP id XAA21444 for
	<pgsql-interfaces@postgreSQL.org>;
	Wed, 5 Aug 1998 23:05:58 -0400 (EDT)
Received: from mustang.sdc.com.au (localhost [127.0.0.1]) by
	mustang.sdc.com.au (8.8.8/8.6.12) with ESMTP id MAA13230;
	Thu, 6 Aug 1998 12:35:00 +0930
Message-Id: <199808060305.MAA13230@mustang.sdc.com.au>
X-Mailer: exmh version 2.0.2 24/2/98
To: Pierluigi <pgsql@sif.it>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC DATE PROBLEM 
In-reply-to: Your message of "Tue, 04 Aug 1998 18:01:41 +0200."
	<35C73065.744861C@sif.it>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Thu, 06 Aug 1998 12:35:00 +0930
From: Stephen Davies <scldad@sdc.com.au>

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@sdc.com.au
Adelaide, South Australia.     			                            Voice: 61-8-82728863
Computing & Network solutions.	 	                            Fax: 61-8-82741015