daylight saving -> global database
- From: "bernas, glen" <bernas_glen@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 3 Nov 2004 15:09:54 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
