Oracle gets its time from the operating system, so if the Oracle
database time is wrong, adjust the time on the Oracle server.

Or, is this a case of the time being set by on new records by an
application, so the time may be wrong in the O/S of an application
server or on a client computer?

-----Original Message-----
From: Chad GARRISON
[mailto:oracledba-ezmlmshield-x21297982.[Email address protected]
Sent: Thursday, November 02, 2006 10:46 AM
To: LazyDBA Discussion
Subject: Spam: Time Change

How do I change the time in Oracle? The database time is showing an hour
ahead due to the time change over the weekend.


---------------------------------------------------------------------
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





THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page