Home » SQL & PL/SQL » SQL & PL/SQL » TimeZone
TimeZone [message #217283] Thu, 01 February 2007 08:14
guidosenator
Messages: 1
Registered: February 2007
Junior Member
We have a value of 2007-03-11 0230 in a date field. The data represents a GMT/Zulu time.
When we try to extract it using the JAVA api's, it returns 2007-03-11 0330. We are assuming because 2007-03-11 0230 is not a valid time for our time zone.
Notes:
JVM timezone is EST
Oracle database offset is -5
We know we can change the JVM to run with a defalut timezone of GMT, but we are afraid it might cause other issues. We have searched/posted on a lot of the JAVA forums.

Thanks!!!
Previous Topic: Store Variable in SQL
Next Topic: Sequence no longer exists....
Goto Forum:
  


Current Time: Mon Apr 24 04:31:25 CDT 2017

Total time taken to generate the page: 0.08240 seconds