RE: Unreadable time_stamp format

[Bobak, Mark]

Title: Unreadable time_stamp format

Which I assume means you have no idea how to get a readable date out of that?  A thought, it could a be a julian date of some kind.   I tried several different guesses....none of which panned out.  These types of things usually work better when you have the specs and know what the format of the data was intended to be.  ;-)   There is a reason Oracle has DATE and TIMESTAMP datatypes.   -Mark   PS  I tried several julian date formats, expressed in days, seconds, hundredths of a second, but nothing really looked right.  Also tried microseconds, centiseconds, seconds and says since the epoch (01-JAN-1970), with nothing that looked reasonable. -----Original Message----- From: Nguyen, David M [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: 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