Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group