SQL> create table myTable (
2 event_date date,
3 event_timestamp timestamp );
Table created.
SQL>
SQL> insert into myTable( event_date, event_timestamp )
2 values ( sysdate, sysdate );
1 row created.
SQL>
SQL> column event_date format a18
SQL> column event_timestamp format a28
SQL>
SQL> select to_char(event_date, 'DD-MON-YY HH24:MI:SS') event_date, event_timestamp
2 from myTable;
EVENT_DATE EVENT_TIMESTAMP
------------------ ----------------------------
03-JUN-07 21:14:25 03-JUN-07 09.14.25.000000 PM
SQL> drop table myTable;
Table dropped.