You will have to use the to_char function to return the time format you
wish to see.
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 Mon Sep 28 1998 - 12:10:05 CDT
