Received: from relay.gcom.ru (Garant-Siberia-RadioNET.gcom.ru [194.84.180.33] (may be forged)) by hub.org (8.8.8/8.7.5) with ESMTP id BAA12014 for ; Fri, 17 Apr 1998 01:59:00 -0400 (EDT) Received: from avd.garsib.ru (avd.garsib.ru [194.135.7.99]) by relay.gcom.ru (8.6.10/8.6.10) with ESMTP id MAA03618; Fri, 17 Apr 1998 12:58:19 +0700 Received: (from avd@localhost) by avd.garsib.ru (8.8.7/8.8.7) id NAA00613; Fri, 17 Apr 1998 13:01:49 +0700 (NSS) (envelope-from avd) To: pgsql-interfaces@postgresql.org CC: byronn@insightdist.com Subject: Re: [INTERFACES] Re: ODBC driver and Dates References: <199804160750.RAA27706@mustang.sdc.com.au> <3535FD96.DF9F603F@sid.trust.ee> <353657E1.5955C81C@insightdist.com> From: Aleksey Demakov Date: 17 Apr 1998 13:01:48 +0700 In-Reply-To: Byron Nikolaidis's message of Thu, 16 Apr 1998 15:11:29 -0400 Message-ID: <861zuxvvea.fsf@avd.garsib.ru> Lines: 20 X-Mailer: Gnus v5.3/Emacs 19.34 Byron Nikolaidis 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