time zone not adjusted for future or past
From: Seth <sgelberg_at_optonline.net>
Date: 8 Apr 2002 14:33:55 -0700
Message-ID: <f3159b28.0204081333.571597e8_at_posting.google.com>
Date: 8 Apr 2002 14:33:55 -0700
Message-ID: <f3159b28.0204081333.571597e8_at_posting.google.com>
How can you get oracle to adjust the time you enter in the future to
be the correct time zone.
For example if I entered the following into a column of timestamp with
local time zone, I would expect to get back the 'EST' for the 'EDT' I
inserted, since five days ago was 'EDT'. The time of sysdate was:
03-APR-02 04:59:26 'EST'.
insert into my_tab values (sysdate -5, sysdate -5, sysdate-5);
1 row created.
SQL> select * from my_tab;
03-APR-02 04.59.26 PM
03-APR-02 04.59.26 PM
03-APR-02 04.59.26.000000 PM -04:00
Received on Mon Apr 08 2002 - 23:33:55 CEST