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

Dick,

Will I be right in assuming that while table with columns of type "timestamp with local Timezone" will not be affected but tables with "date" columns and hence the application be affected? Even in 10g there must be some tables with column type "date" and so it may have some impact (like Mladen implies).

Thanks.

On Thu, 24 Feb 2005 17:07:53 -0500, Goulet, Dick <DGoulet_at_vicr.com> wrote:
> 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_at_yahoo.com]=20
> Sent: Thursday, February 24, 2005 3:38 PM
> To: oracle-l_at_freelists.org
> 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
>

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