Re: How to set SYSDATE?

That would be the other way around?
The system runs DST, Oracle not - hence summertime for OS makes Oracle 1 hour late.
When DST ends, both are the same again.

Would it make sense when the database did an update on 02:35 am, only to revoke that
half an hour later, on 02:05 am??? Oracle will not do DST.

--
Frank
Connor McDonald <connor_mcdonald_at_yahoo.com> schreef in berichtnieuws
39BF56A5.5359_at_yahoo.com...


> Mr. Poologic wrote:

> >

> > SYSDATE is one hour ahead of the operating system time our our


> > VMS system.  How can that happen.  How is SYSDATE set in the first

> > place?

> >

> > --

> > http://members.aol.com/tadamsmar/poologic.htm

> > Java applet that calculates your best college

> > hoops tourney pool sheet

> >

> > Sent via Deja.com http://www.deja.com/

> > Before you buy.

>

> Its probably due to a timezone setting (and thus a summertime setting)

> that the db has possibly picked up

>

> HTH

> --

> ===========================================

> Connor McDonald

> http://www.oracledba.co.uk

>

> We are born naked, wet and hungry...then things get worse