Re: time zone not adjusted for future or past
Date: Tue, 09 Apr 2002 01:13:19 GMT
Message-ID: <Pers8.251669$q2.28633_at_sccrnsc01>
You would have to manage daylight savings yourself. Oracle knows nothing
about daylight savings. (The rules have varied over time and also vary with
country.) Sysdate is the time now on the server, Oracle gets the time from
the server and does not maintain its own inner clock. If you subtract 5
from the time you get the time 5 days ago.
Jim
"Seth" <sgelberg_at_optonline.net> wrote in message
news: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 Tue Apr 09 2002 - 03:13:19 CEST