Re: SYSDATE and System Time

From: Fraser McCallum <fmcc_at_NOSPAModbaguru.com>
Date: Mon, 28 Jan 2002 16:10:36 -0000
Message-ID: <GJe58.3880$oK1.36776@NewsReader>

James,

If you change the underlying UNIX date after start then the Oracle SYSDATE does not change. Also there are various ways to start Oracle with a different time than the root UNIX time, one of which is to alter the UNIX time of the user starting Oracle.

Kind Regards

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"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 Mon Jan 28 2002 - 10:10:36 CST