Skip to Main Content

New to Java

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DST - daylight savings time

807599Jan 24 2007 — edited Feb 2 2007
OK ... I know there are several posts on this, I have read them all and tried a lot of the JVM's (1.4.2_11, 1.5_09, 1.6.0) and get the same results. We store dates in an Oracle database(9i). These dates represent dates in GMT/Zulu.

So...here is the issue/question. We have a date/time stored in the database of 2007-03-11 0230. This really isn't a valid date for local (Eastern), but it is for GMT. It isn't a valid date for local, because at 0200 (really one second past), we jump forward to 0300.

When we pull this date out of the database, using resultSet.getString() or resultSet.getTimeStamp()....or anything else, it converts the date from: 2007-03-11 0230 to 2007-03-11 0330.

This should not be converted, this specific field in the database represents a Z/GMT time, so we don't want any conversions done on this date, when pulling it from the database.

Any ideas where I'm going wrong???

Thanks!!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2007
Added on Jan 24 2007
9 comments
343 views