dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1611: reading a date-field by "ResultSet.getTimestamp()" method analized dayligth flag in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ingolf Knopf
 
Posts: n/a

Default [BUGS] BUG #1611: reading a date-field by "ResultSet.getTimestamp()" method analized dayligth flag - 04-21-2005 , 08:32 AM







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".

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.