Re: SYSDATE and System Time

From: Tianhua Wu <tianhua.wu_at_mirant.com>
Date: 29 Jan 2002 06:41:24 -0800
Message-ID: <18e503ea.0201290641.679ea250@posting.google.com>

One way to use a different time zone is set TZ, then start your listener. So if you connect through the listener, you will use that time tone. However, you unix time zone is still the old one. And if you do not connect through the listener, you still see the same time zone as unix.

Tianhua Wu

James Hanway <hanwayj_at_m1a2r3.dfo-mpo.gc.cax> wrote in message news:<3C555F7D.F0791988_at_m1a2r3.dfo-mpo.gc.cax>...
> I have a co-worker with an 8.1.6 database on Tru64 5.x
>
> Her sysdate is reporting a different time then what the UNIX date is
> returning.
>
> Has anyone ever experienced this?
>
> Cheers,
>
> James
Received on Tue Jan 29 2002 - 08:41:24 CST