or in SQL*Plus:
set numwidth 20
- Jared.Still_at_radisys.com wrote:
> column time_stamp format 999999999999999999999 head 'TIME STAMP'
>
>
>
>
>
> "Nguyen, David M" <david.m.nguyen_at_xo.com>
> Sent by: ml-errors_at_fatcity.com
> 12/16/2003 01:39 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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
>
>
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 - 18:59:25 CST
