David - This is not a date column. It is some type of number column (see
type number(20) ). You need to find the program that writes to this column
to find what the interpretation is. You may also want to
column time_stamp format 99999999999999999999
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
Sent: Wednesday, March 05, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
I try to query a report to check user activity but I could not read date
column. Is there a way to reformat the column to be readable? Date colum
calls "time_stamp" as shown below.
SQL> desc user_activity_log
Name Null? Type
----------------------------------------- -------- --------------
TIME_STAMP NOT NULL NUMBER(20)
NODE_NAME NOT NULL VARCHAR2(20)
USER_NAME NOT NULL VARCHAR2(20)
CLIENT_IP NOT NULL VARCHAR2(15)
DESCRIPTION NOT NULL VARCHAR2(2048)
SQL> select user_name,client_ip,node_name,time_stamp from user_activity_log
where user_name = 'admin'
order by time_stamp;
USER_NAME CLIENT_IP NODE_NAME TIME_STAMP
-------------------- --------------- -------------------- ----------
admin NA Insight Server 1.0397E+12
admin NA Insight Server 1.0402E+12
admin NA Insight Server 1.0433E+12
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
