RE: Unreadable time_stamp format

[Nguyen, David M]

Title: Unreadable time_stamp format

Now I got.   USER_NAME             TIME STAMP --------------------              ---------------------- eholley                       1069716948959 jmdavis                       1069715246467 jmdavis                       1069715324466     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bobak, Mark Sent: Tuesday, December 16, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: 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;   -----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 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