Re: [BUGS] BUG #1611: reading a date-field by "ResultSet.getTimestamp()"

#1

Ingolf Knopf wrote:

Quote:

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

Can you provide a compilable test case please?

What is the behaviour of Oracle/Ingres with the same test case?

-O

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #1611: reading a date-field by "ResultSet.getTimestamp()"

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

Re: [BUGS] BUG #1611: reading a date-field by "ResultSet.getTimestamp()" - 04-21-2005 , 06:17 PM