Postgres Pro
Downloads
Home   >   mailing lists

Re: ISO8601 Time and ODBC - Mailing list pgsql-interfaces

From Thomas Lockhart
Subject Re: ISO8601 Time and ODBC
Date
Msg-id 39BCFC88.5629FC7E@alumni.caltech.edu
Whole thread Raw
In response to ISO8601 Time and ODBC  ("Carl Shelbourne" <Carl.Shelbourne@marconi.com>)
List pgsql-interfaces
Tree view 
> Does anybody know how I can get the offset to the time returned by Postgres
> using ODBC??, this is not included in the above struct.

select date_part('timezone', timefield)

will do it, so just return another column in the query.
                   - Thomas

pgsql-interfaces by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: obtaining primary key/rowid following insert, redux...
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] JDBC Patch