Re: SYSDATE and System Time

Hi

check out fixed_date as well!!

cheers

Pete Finnigan
www.pentest-limited.com

In article <GJe58.3880$oK1.36776_at_NewsReader>, Fraser McCallum <fmcc_at_NOSPAModbaguru.com> writes
>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
>>
>
>

-- 
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager at admin_at_pentest-limited.com
--
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com