Message-Id: <199804170652.QAA27480@mustang.sdc.com.au>
To: Aleksey Demakov <avd@avd.garsib.ru>
cc: pgsql-interfaces@postgreSQL.org, byronn@insightdist.com
Subject: Re: [INTERFACES] Re: ODBC driver and Dates 
In-reply-to: Your message of "17 Apr 1998 13:01:48 +0700."
	<861zuxvvea.fsf@avd.garsib.ru>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Fri, 17 Apr 1998 16:22:48 +0930
From: Stephen Davies <scldad@sdc.com.au>

Surely the way to go is to retrieve the date style from Windows. That is, use 
the setting in Control Panel Regional Settings.

This can also be used to pick up decimal point and currency settings.

Cheers,
Stephen.

> Byron Nikolaidis <byronn@insightdist.com> writes:
> 
> > Should the driver query the database (i.e., "show datestyle") to see what format
> > it should use, -OR-, should it be an option for the datasource, where you select
> > what style to use, and the driver sets the style when it makes a connection
> > ("set datestyle")?
> 
> I beleave there is no need for such an option. The only thing is
> needed that ODBC-driver and Postgres use the same format during
> connection. Thus opening connection ODBC-driver should always set
> the datestyle which it uses. Asking the datestyle from backend and
> than using appropriate conversion is posible but why to bother with
> this while the opposite (instructing backend what datestyle to use)
> is much simpler to implement and will work equaly well?
> 
> Aleksey
> 
> -- 
> Aleksey Demakov
> avd@avd.garsib.ru


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