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

Home -> Community -> Mailing Lists -> Oracle-L -> Timestamp with [local] time zone changes for 2007 DST changes in US

Timestamp with [local] time zone changes for 2007 DST changes in US

From: Jesse, Rich <Rich.Jesse_at_qg.com>
Date: Wed, 25 Oct 2006 13:44:46 -0500
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697A523F2@QTEX1.qg.com>


Hey all,

Anyone else investigating how Oracle will be affected by the 2007 DST changes in the US? It seems to me that the only DBs to worry about are those that have columns with the TIMESTAMP WITH [LOCAL] TIME ZONE datatype and have a nonnumeric timezone set. I have none that have nonnumeric TZs, but it would seem that every 10g DB that does would be affected since the data dictionary contains those datatypes.

Of course, every server we have needs OS patches, which will undoubtably require reboots...<sigh>

Just wondering...

Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 25 2006 - 13:44:46 CDT

Original text of this message

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