ODBC driver does not return time zone for CURRENT_TIMESTAMP
am 06.11.2009 17:06:08 von the6campbells--0015174c37409f792c0477b6050f
Content-Type: text/plain; charset=ISO-8859-1
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.
--0015174c37409f792c0477b6050f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
If so what is the ref#
ike
d value. Expecting something like
=A0icol, szColName, *=
pcbColName, *pfSqlType, *pcbColDef, *pibScale, *pfNullable
=
=A01, now, 3, SQL_TYPE_TIMESTAMP=3D93, 26, 6, SQL_NULLABL=
E=3D1
"now"
2009-11-06 10:44:36.583000000
1=
row fetched from 1 column.
CURRENT_TIMES=
TAMP deliver values with time zone; LOCALTIME and --0015174c37409f792c0477b6050f--