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

BUG #5187: odbc driver not returning time zone

From: "the6campbells" <the6campbells(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5187: odbc driver not returning time zone
Date: 2009-11-14 16:52:03
Message-ID: 200911141652.nAEGq3K3075882@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5187
Logged by:          the6campbells
Email address:      the6campbells(at)gmail(dot)com
PostgreSQL version: 8.4.1
Operating system:   windows
Description:        odbc driver not returning time zone
Details: 

ODBC driver not returning time zone for CURRENT_TIMESTAMP. 


 select CURRENT_TIMESTAMP from TVERSION


The same test run via the SQL GUI from pgadmin will return something like

"2009-11-06 10:42:33.944-05"

Mean while via ODBC note the precision on the describe and the returned
value. Expecting something like

2009-11-06 08:00:34.980000+00:00 not what is being returned.

Describe Column All:
         icol, szColName, *pcbColName, *pfSqlType, *pcbColDef, *pibScale,
*pfNullable
           1, now, 3, SQL_TYPE_TIMESTAMP=93, 26, 6, SQL_NULLABLE=1

Get Data All:
"now"
2009-11-06 10:44:36.583000000
1 row fetched from 1 column.

CURRENT_TIME and CURRENT_TIMESTAMP deliver values with time zone;
LOCALTIMEand
LOCALTIMESTAMP deliver values without time zone.

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2009-11-14 17:12:33
Subject: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"
Previous:From: Tom LaneDate: 2009-11-14 16:26:50
Subject: Re: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable"

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