Re: How do we change Oracle's Time?

Glynn C Taylor wrote:
>
> How do we change Oracle's view of what time it is without re-installing
> o the database? The system time is correct, but when we select sysdate
> from dual, the time is off by 4 hours. Thanks in advance.
> Glynn Taylor
 

-- 

Check to see that your Oracle processes including orasrv / tnslsnr are 
running on correct timezone setting (env. variable TZ on Unix).
Hope this helps you...

Timo Haatainen
Carelcomp Forest Oy