Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> daylight saving -> global database

daylight saving -> global database

From: bernas, glen <bernas_glen_at_emc.com>
Date: Wed, 3 Nov 2004 15:09:54 -0500
Message-ID: <7FAAE4DE7248554ABD8C69DD4A18289B0539B075@srnamath-bkp.lss.emc.com>


I have a global database and we have implemented data types "timestamp with local time zones"
This works great, clients inform the database which time zone their in and they get the correct time,

My problem is day light savings. Do we move the database time a back an hour? We move the Host time clock back?? I don't really know what to do so the timestamps don't get messed up.

Currently the server is off by an hour . and we don't know what to do or know the implications of any of our actions.


Glen Bernas
Database Administrator

        EMC˛
where information lives

Phone:

          Direct: (508) 249-2237
          Ext: 42237




--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 03 2004 - 14:06:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US