Oracle-L: RE: Date format is unreadable

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 05 Mar 2003 13:09:49 -0800
Message-ID: <F001.0056156F.20030305130949@fatcity.com>

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.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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). Received on Wed Mar 05 2003 - 15:09:49 CST