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

Re: [INTERFACES] Re: ODBC driver and Dates

From: Aleksey Demakov <avd(at)avd(dot)garsib(dot)ru>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: byronn(at)insightdist(dot)com
Subject: Re: [INTERFACES] Re: ODBC driver and Dates
Date: 1998-04-17 06:01:48
Message-ID: 861zuxvvea.fsf@avd.garsib.ru (view raw or flat)
Thread:
Lists: pgsql-interfaces
Byron Nikolaidis <byronn(at)insightdist(dot)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(at)avd(dot)garsib(dot)ru

In response to

Responses

pgsql-interfaces by date

Next:From: Stephen DaviesDate: 1998-04-17 06:52:48
Subject: Re: [INTERFACES] Re: ODBC driver and Dates
Previous:From: Julia A.CaseDate: 1998-04-17 05:35:22
Subject: Re: [INTERFACES] Re: [QUESTIONS] ODBC Driver and Install script (PLEASE READ!)

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