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

From Ingolf Knopf
Subject BUG #1611: reading a date-field by "ResultSet.getTimestamp()" method analized dayligth flag
Date
Msg-id 20050421123216.0C52BF0C14@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1611: reading a date-field by "ResultSet.getTimestamp()"
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1611
Logged by:          Ingolf Knopf
Email address:      iknopf@csc-dd.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".

pgsql-bugs by date:

Previous
From: "Olleg Samoylov"
Date:
Subject: BUG #1610: rewrite rule and sequence
Next
From: Oliver Siegmar
Date:
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps