Oracle TIMESTAMP WITH TIMEZONE and JDBC inserts/selects
Posted on 2005-04-06
I'm having a problem with date and time with timezone manipulation.
There is a table in an Oracle 10g database that is created like this:
create table eventLocalGMT (
gmtDate TIMESTAMP WITH TIMEZONE);
The idea behind this is to be able to store data in the same table "as is" AND "GMT". For example, if an event occurs at 24/10/2005 10:00 GMT+2, the data would be stored as:
localDate = 24/10/2005 10:00
gmtDate = 24/10/2005 08:00 (GMT 0)
How can inserts and select queries be done in java through JDBC if I start with a java.util.Date initialized as the client's local date and time?