Re: Oracle daylight saving

Oracle also uses an internal time that is not related to the server time in order to record transactions. Other wise you would have trouble with SCN numbers when recovering or backing up a database. This internal time is based on the number of seconds from a set date in the past, which I believe someone told me was the moment oracle was incorporated.

Tim Boles

Original from :John Dunn john.dunn_at_sefas.co.uk

> Received: by mx.citynet.net (mbox cx86193)
> (with Cubic Circle's cucipop (v1.31 1998/05/13) Tue Nov 12 14:52:23 2002)
> X-From_: root_at_fatcity.cts.com Mon Nov 11 08:38:11 2002
> Return-Path: <root_at_fatcity.cts.com>
> Received: from rx2.wvinternetservices.com (rx2.wvinternetservices.com [66.118.65.11])
> by mx.citynet.net (8.12.4/8.12.4=Hub) with ESMTP id gABDcAZ3019678
> for <timboles_at_citynet.net>; Mon, 11 Nov 2002 08:38:10 -0500
> Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
> by rx2.wvinternetservices.com (8.12.5/8.12.5=Inbound+AV) with ESMTP id gABDXIbE015775
> for <timboles_at_citynet.net>; Mon, 11 Nov 2002 08:33:19 -0500
> Received: from fatcity.UUCP (uucp_at_localhost)
> by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA35355;
> Mon, 11 Nov 2002 05:35:52 -0800 (PST)
> Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004FFF76; Mon, 11 Nov 2002 04:58:36 -0800
> Message-ID: <F001.004FFF76.20021111045836_at_fatcity.com>
> Date: Mon, 11 Nov 2002 04:58:36 -0800
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> X-Comment: Oracle RDBMS Community Forum
> X-Sender: John Dunn <john.dunn_at_sefas.co.uk>
> Sender: root_at_fatcity.com
> Reply-To: ORACLE-L_at_fatcity.com
> Errors-To: ML-ERRORS_at_fatcity.com
> From: John Dunn <john.dunn_at_sefas.co.uk>
> Subject: Oracle daylight saving
> Organization: Fat City Network Services, San Diego, California
> X-ListServer: v1.0g, build 72; ListGuru © 1996-2001 Bruce A. Bergman
> Precedence: bulk
> Mime-Version: 1.0
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> How does Oracle handle daylight saving time changes. presumably it gets its
> time from the OS?
>
> John
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> .

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: timboles_at_citynet.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).