BUG #1611: reading a date-field by "ResultSet.getTimestamp()" method analized dayligth flag

From: "Ingolf Knopf" <iknopf(at)csc-dd(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1611: reading a date-field by "ResultSet.getTimestamp()" method analized dayligth flag
Date: 2005-04-21 12:32:16
Message-ID: 20050421123216.0C52BF0C14@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1611
Logged by: Ingolf Knopf
Email address: iknopf(at)csc-dd(dot)de
PostgreSQL version: 8.0.1
Operating system: JDBC
Description: reading a date-field by "ResultSet.getTimestamp()"
method analized dayligth flag
Details:

Retrieving data by "java.sql.ResultSet" I read a data from a column which
has type DATE. I read content of this column by method
"ResultSet.getTimestamp( int )".
I get a "java.sql.Timestamp"-object, where Calendar.HOUR_OF_DAY==1. I
suppose, this is daylight flag.

Maybe this behavior of your JDBC driver is compatible with SQL standard, but
it is completely other than the behavior of "Oracle" or "Ingres".

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marc Soleda 2005-04-21 13:56:35 BUG #1612: Problem with PGAPI_SetPos
Previous Message Olleg Samoylov 2005-04-21 12:19:44 BUG #1610: rewrite rule and sequence