RE: ** impact of time clock changes on Running Oracle DB

Joshi,

        I'm going to make the assumption that your running Oracle 9i or
10g.  Maybe that's a bad assumption, but you can correct me if I'm
wrong.  Reason that I mention this is that if your using "timestamp with
local timezone"  as your date data type then there is no time change as
far as the database is concerned.  This is because Oracle converts the
local date/time to GMT, or Greenwich Mean Time or ZULU, before storing
it and GMT does not change at all.  Otherwise you should see absolutely
no problems.  Been happening to my servers twice a year for 13 years
now.

-----Original Message-----
From: A Joshi [mailto:ajoshi977@xxxxxxxxx]=20
Sent: Thursday, February 24, 2005 3:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ** impact of time clock changes on Running Oracle DB

Hi,
  I would like to know the impact of changing the time on my UNIX
machine. how would it impact a ORACLE database running on the server. I
think Oracle takes its sysdate from the UNIX. Thanks for your help.=20
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: