Date format is unreadable

[Nguyen, David M]

I try to query a report to check user activity but I could not read date column.  Is there a way to reformat the column to be readable?  Date colum calls "time_stamp" as shown below.   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,client_ip,node_name,time_stamp from user_activity_log      where user_name = 'admin'      order by time_stamp;   USER_NAME            CLIENT_IP       NODE_NAME            TIME_STAMP -------------------- --------------- -------------------- ---------- admin                NA              Insight Server       1.0397E+12 admin                NA              Insight Server       1.0402E+12 admin                NA              Insight Server       1.0433E+12