RE: Unreadable time_stamp format

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 16 Dec 2003 14:34:25 -0800
Message-ID: <F001.005DA1CB.20031216143425@fatcity.com>

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:david.m.nguyen@xo.com]
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: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] 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:david.m.nguyen@xo.com]
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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bobak, Mark
  INET: Mark.Bobak_at_il.proquest.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 Tue Dec 16 2003 - 16:34:25 CST