Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Read GMT dates in Java

Re: Read GMT dates in Java

From: Gary Gapinski <glg_at_apk.net>
Date: Thu, 29 Nov 2001 21:25:19 -0500
Message-ID: <3C06EE0F.DA7772C4@apk.net> 





You are likely on an earlier version of Oracle than 9i. It took them a
couple of decades, but they finally got timestamps right in 9i.



I had the misfortune to find that Oracle 8.1.5 (haven't tested it yet on
later 8.1 versions) appears to corrupt dates by shifting them on
delivery via JDBC.



I ended up (wrongly or not) forcing the default timezone to UTC prior to
JDBC accesses in order to coerce Oracle to deliver correct (unshifted)
timestamps.
Received on Thu Nov 29 2001 - 20:25:19 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US