-
from_tz function
Hi
This is used to convert ntimestamp field in AUD$ table to timestamp field of dba_audit_trail view.
cast ( /* TIMESTAMP */
(from_tz(ntimestamp#,'00:00') at local) as date),
What is the syntax to convert it back to query AUD$ table so that dates I selecting from dba_audit_trial were in sinc with AUD$
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|