A little help with TIMESTAMPS (sys.aud$)?
- From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Dec 2013 12:04:49 -0600
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?
Chris
Other related posts:
