A little help with TIMESTAMPS (sys.aud$)?

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Wed, 11 Dec 2013 12:04:49 -0600
Message-ID: <CAP79kiTGeB2z0q5oXZ7aK07i+xUTUZOi2vR5MqcQpx7S3XFG3Q_at_mail.gmail.com>

Ok, I'm feeling stupid as I don't have much experience with timestamp columns with timezones.

I'm looking at SYS.AUD$ and I'm really confused.

Here's what I'm selecting as I try to understand:

select sysdate, systimestamp, max(ntimestamp#), max(ntimestamp#) at time zone 'UTC', max(ntimestamp#) at time zone 'America/Chicago' from sys.aud$ /

sysdate = 12/11/2013 11:56:27 AM
systimestamp = 12/11/2013 11:56:27.038059 AM -06:00

max(ntimestamp#) = 12/11/2013 5:56:02.962863 PM
max(ntimestamp#) at time zone 'UTC' = 12/11/2013 11:56:02.962863 PM +00:00
max(ntimestamp#) at time zone 'America/Chicago' = 12/11/2013 5:56:02.962863
PM -06:00

How are the rows getting inserted with a higher time value into sys.aud$ than the current systimestamp? I would have expected the max(ntimestamp#) to be less than systimestamp when converted to the local time zone?

It appears to be basically 12 hours ahead? +6.00?

What am I missing?


Received on Wed Dec 11 2013 - 19:04:49 CET

Original text of this message