Received: from golem.jpl.nasa.gov (IDENT:postfix@dialin-088.jpl.nasa.gov
	[128.149.231.88])
	by hub.org (8.10.1/8.10.1) with ESMTP id e8BFUJX34611
	for <pgsql-interfaces@postgresql.org>;
	Mon, 11 Sep 2000 11:30:19 -0400 (EDT)
Received: from alumni.caltech.edu (localhost.localdomain [127.0.0.1])
	by golem.jpl.nasa.gov (Postfix) with ESMTP
	id 80A3E807B; Mon, 11 Sep 2000 15:38:48 +0000 (UTC)
Message-ID: <39BCFC88.5629FC7E@alumni.caltech.edu>
Date: Mon, 11 Sep 2000 15:38:48 +0000
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
Organization: Yes
X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdksmp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Carl Shelbourne <Carl.Shelbourne@marconi.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ISO8601 Time and ODBC
References: <80256952.00549D8D.00@marconicomms.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200009/41

> 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