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

Home -> Community -> Mailing Lists -> Oracle-L -> Handling Daylight Savings Time

Handling Daylight Savings Time

From: TSAWMILL.US.ORACLE.COM <TSAWMILL_at_US.ORACLE.COM>
Date: Thu, 25 Jan 1996 08:53:11 -0500
Message-Id: <9601251950.AA29612@alice.jcc.com>


Has anybody come up with a good method to handle Daylight Savings Time
"anomalies"? The problem: we have rows that have date/time as part of a
unique key. How would one elegantly handle incoming data, on that blessed day in October when we get an extra hour of sleep, that has a duplicate key because the info being recorded happened at 1:00am EDT and also at 1:00am EST?  I would hate to have an extra field indicating DST just for something happens only once a year. Any ideas?

Tim Sawmiller
tsawmiller_at_us.oracle.com
"The opinions expressed here are my own and not necessarily those of the
Oracle Corporation". Received on Thu Jan 25 1996 - 14:51:01 CST

Original text of this message

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