Re: SYSDATE and System Time

Want to know something embarrassing? The person had the incorrect mask in the TO_CHAR funtion: Used MM for minutes, rather than MI.

But thanks for the other information. It'll be useful toknow

Pete Finnigan wrote:

> 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
Received on Tue Jan 29 2002 - 08:09:31 CST