Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Universal date/time in Oracle and JDBC
I am developing an application that has to span multiple time zones. In order to facilitate this, the clock on the database server is set to UTC. The problem I am having is that Oracle or its JDBC driver don't seem to understand this idea of spanning multiple time zones:
The problem I'm having is that Oracle stores the date/time based on the time zone in which the date was entered; i.e. no matter what machine I go to the JDBC driver returns the date/time as today at 13:30.
Is there any way to tell the JDBC driver that all dates are UTC? I really don't want to have to write wrappers around all my date selects, inserts, and updates. Any help would be greatly appreciated.
-- Remove NOSPAM woven into e-mail address to reply directly.Received on Fri Jun 01 2001 - 12:27:45 CDT