Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Audit Trails...

Re: Audit Trails...

From: Dave Klinger <dklinger_at_bechtel.com>
Date: Mon, 28 Sep 1998 19:32:59 GMT
Message-ID: <360FE46A.7B3A0A4@bechtel.com>


The default date format from Oracle is to display the date only. You can change it for just your specific query using the TO_CHAR function. Example: Select to_char(logon_time,'Month DD YYYY HH24:MIN') from v$session; You can define whatever format you would like, this is just one example. There is a table of codes that are available for the Date Formats. You can also change the date format for your entire session using the ALTER SESSION command with the NLS_DATE_FORMAT parameter. This would change the date output on any query you run for that particular session.

Dave

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 - 14:32:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US