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 [EMAIL PROTECTED] > 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_: [EMAIL PROTECTED] Mon Nov 11 08:38:11 2002 > Return-Path: <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]>; 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 <[EMAIL PROTECTED]>; Mon, 11 Nov 2002 08:33:19 -0500 > Received: from fatcity.UUCP (uucp@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: <[EMAIL PROTECTED]> > Date: Mon, 11 Nov 2002 04:58:36 -0800 > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > X-Comment: Oracle RDBMS Community Forum > X-Sender: John Dunn <[EMAIL PROTECTED]> > Sender: [EMAIL PROTECTED] > Reply-To: [EMAIL PROTECTED] > Errors-To: [EMAIL PROTECTED] > From: John Dunn <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
