Most people use daylight savings when changing the time in order to avoid
consistency problems.

Adam Hudspith
Technical Analyst
Systems Services
House of Fraser

[Email address protected]
01793 690360



-----Original Message-----
From: Mukarram Shah
[mailto:oracledba-ezmlmshield-x28093387.[Email address protected]
Sent: 31 October 2006 14:45
To: LazyDBA Discussion
Subject: RE: date change

It will affect all the database cron jobs listed on unix server on which
time is changed. Secondly all your date time stamps on tables will
reflect the changed time when such an insert is made.

These are the two big ones I can think of

Mukarram

-----Original Message-----
From: Abdul Wahab Ansari
[mailto:oracledba-ezmlmshield-x49605318.[Email address protected]
Sent: Tuesday, October 31, 2006 7:24 AM
To: LazyDBA Discussion
Subject: date change

Hello dba,
What could happen if the date on the unix servers running production db
is changed ?

abdul




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

****************************************************************************
****
IMPORTANT NOTICE

House of Fraser (Stores) Limited
Registered office: Granite House, 31 Stockwell Street, Glasgow G1 4RZ
Company Number: 10677

If you have received this e-mail in error, please notify the sender and
delete the e-mail and attachments immediately. This e-mail (including any
attachments) may contain confidential and/or privileged information. If you
are not the intended recipient, any reliance on, use, disclosure,
dissemination, distribution or copying of the e-mail or attachments is
strictly prohibited.
We have checked for viruses but the content of an attachment may still
contain software viruses, which could damage your computer system. We do not
accept liability for any damage you sustain as a result of a virus
introduced by this e-mail or attachment and you are advised to use
up-to-date virus checking software. E-mail transmission cannot be guaranteed
to be secure or error free.
This e-mail is not intended nor should it be taken to create any legal
relations, contractual or otherwise.
To view our latest in-store news click on: http://www.houseoffraser.co.uk

****************************************************************************
****

Oracle LazyDBA home page