Re: ISO8601 Time and ODBC

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Carl Shelbourne <Carl(dot)Shelbourne(at)marconi(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: ISO8601 Time and ODBC
Date: 2000-09-11 15:38:48
Message-ID: 39BCFC88.5629FC7E@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> 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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2000-09-12 04:16:57 Re: [PATCHES] JDBC Patch
Previous Message Ross J. Reedstrom 2000-09-11 14:46:37 Re: obtaining primary key/rowid following insert, redux...