Re: Adjusting the system clock?

    The problem isn't with Oracle, but with being careful of any apps that refer to dates. For example if any tables have a date posted field that uses sysdate, what will you do about all the rows that are already filled in? And when daylight savings time comes, how do you handle the loss of an hour? Data B posted 59 minutes after Data A may show up in the database as having been posted before Data A. Perhaps none of your apps will be affected by changing the system clock, but you should be sure.

    By the way, as we've moved to apps that run internationally, we're storing all dates - in the database - as GMT. We can always decide what we want to present to the user at a particular location, but what's in the database itself remains consistent.

Van

<gdas_at_my-deja.com> wrote in message news:961o30$mvm$1_at_nnrp1.deja.com...
> Hi,
>
> Aside from time-based scripts. Are there any implications I need to be
> aware of in regards to resetting the system clock? This is with Oracle
> 8.1.6 on Windows 2000.
>
> We've recently configured a set of servers out in a datacenter on the
> East coast. And the machines are running in EST. We are in the
> pacific time zone and our application doesn't yet have timezone
> awareness, so we are considering simply putting the clocks back on
> those machines 3 hours.
>
> Will this have any adverse effects on Oracle? The system is not live
> yet, but we plan to go live next week. My biggest fear is that by
> doing this the database won't startup or mount or we might have other
> unexpected low level oracle problems.
>
> Any thoughts?
> Thanks,
> Gavin
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Feb 10 2001 - 09:23:56 CST