| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2009-11-14 17:12:33 | Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable" |
| Previous Message | Tom Lane | 2009-11-14 16:26:50 | Re: Re: BUG #5065: pg_ctl start fails as administrator, with "could not locate matching postgres executable" |