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

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Wed, 11 Dec 2013 14:04:27 -0600
Message-ID: <CAP79kiTij-OJdP2pyh8Ns0OEw=BJ116422sYbWMgEkqq4fheag_at_mail.gmail.com>

Thanks for the reply - that helped and what I figured​ out is this:

max(ntimestamp#) at time zone 'America/Chicago' only gives me the UTC time -6:00 - it still doesn't show me a local time.

However, using:

select ... from_tz(max(ntimestamp#),'UTC') at time zone 'America/Chicago' or
select ... from_tz(max(ntimestamp#),'UTC') at local

both give me the local time I was looking for.

Thanks again,
Chris

On Wed, Dec 11, 2013 at 12:35 PM, rjamya <rjamya_at_gmail.com> wrote:

> ntimestamp# is stored as of UTC, it is interpreted into current TZ in
> dba_audit_trail view. see
> http://jonathanlewis.wordpress.com/2010/04/05/failed-login/ for some
> discussion on this.
>
> Raj
>
>
> On Wed, Dec 11, 2013 at 1:04 PM, Chris Taylor <
> christopherdtaylor1994_at_gmail.com> wrote:
>
>>
>> What am I missing?
>>
>>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 11 2013 - 21:04:27 CET