Re: Timestamp used for messages in alert log after machine timezone change
From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Thu, 22 Sep 2011 13:18:03 +0100
Message-ID: <CAPMSPxMf3W3F-OrGs_n1qyZje5uFCLSFLcGq1NSNkt=pN7H2jw_at_mail.gmail.com>
I have found the the timestamp returned by systimestamp is in the new timezone when connecting to the database with a local bequeath connection, but when the connection is done via TNS it is in US Eastern time. Still investigating.
Date: Thu, 22 Sep 2011 13:18:03 +0100
Message-ID: <CAPMSPxMf3W3F-OrGs_n1qyZje5uFCLSFLcGq1NSNkt=pN7H2jw_at_mail.gmail.com>
I have found the the timestamp returned by systimestamp is in the new timezone when connecting to the database with a local bequeath connection, but when the connection is done via TNS it is in US Eastern time. Still investigating.
Pete
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 22 2011 - 07:18:03 CDT