ODBC driver does not return time zone for CURRENT_TIMESTAMP

From: the6campbells <the6campbells(at)gmail(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC driver does not return time zone for CURRENT_TIMESTAMP
Date: 2009-11-06 16:06:08
Message-ID: 22431f1b0911060806n4a3cbc0byc20d9d637239c43@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

ODBC driver not returning time zone for CURRENT_TIMESTAMP. Known bug? If so
what is the ref#

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.

Browse pgsql-odbc by date

  From Date Subject
Next Message ikorot 2009-11-16 02:08:49 Table creation
Previous Message cholid 2009-11-05 15:49:56 Database connection error, try to reset the connection parameters