Re: Audit Trails...

From: John Durst <jdurst_at_sky.net>
Date: Tue, 29 Sep 1998 23:34:20 -0500
Message-ID: <3611B4CC.D05D3F77@sky.net>

If you don't do a to_char of a date field, then NLS_DATE_FORMAT is the format used to display a date(/time) field. The default format is DD-MON-YY. You could do something similar to the following to see the full date/time of a date field:

ALTER SESSION SET NLS_DATE_FORMAT="mm/dd/yyyy hh24:mi:ss";

Erik wrote:

> Hello, can anyone help to answer my questions :
>
> In our site, the Oracle8 was installed under HP-UX. When I reviewed the
> audit trails (e.g. select * from dba_audit_session) by using SQL*Plus, only
> date was shown under the column timestamp. However, if I use MS-Access
> through ODBC, I can get both time and date for the column timestamp. Is it
> related to NLS parameters ? How can I see the time information using
> SQL*Plus ?
>
> Thanks in advance.
>
> Regards/Erik
Received on Tue Sep 29 1998 - 23:34:20 CDT