-----Original Message-----
From: Nguyen, David M [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Unreadable time_stamp formatI 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
Title: Unreadable time_stamp format
Since
it's a NUMBER datatype, try:
SQL> column time_stamp format
99999999999999999999
SQL> select user_name, time_stamp from
USER_ACTIVITY_LOG;
- Unreadable time_stamp format Nguyen, David M
- Re: Unreadable time_stamp format Jared . Still
- RE: Unreadable time_stamp format Bobak, Mark
- RE: Unreadable time_stamp format Nguyen, David M
- Re: Unreadable time_stamp format Mladen Gogala
- RE: Unreadable time_stamp format Bobak, Mark
- RE: Unreadable time_stamp format Stephen.Lee
- Re: Unreadable time_stamp format Rachel Carmichael
- RE: Unreadable time_stamp format Jared . Still
- RE: Unreadable time_stamp format Nguyen, David M
- RE: Unreadable time_stamp format Jared . Still
- RE: Unreadable time_stamp format Nguyen, David M