column time_stamp format 999999999999999999999 head 'TIME STAMP'
"Nguyen, David M" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 12/16/2003 01:39 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Unreadable time_stamp format |
I need to view time_stamp column in USER_ACTIVITY_LOG table but it displays unreadable format as shown below. Is there a way to decode it to be readable?
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, time_stamp from USER_ACTIVITY_LOG;
edscott 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
jmdavis 1.0693E+12
edscott 1.0693E+12
edscott 1.0693E+12
Thanks,
David