SQL> -- use timestamp
SQL>
SQL> create table company_events (
2 event_name varchar2( 100 ),
3 event_date date,
4 event_timestamp timestamp )
5 /
Table created.
SQL>
SQL> insert into company_events ( event_name, event_date, event_timestamp )
2 values ( 'Name 1', sysdate, sysdate )
3 /
1 row created.
SQL> column event_name format a28
SQL> column event_date format a18
SQL> column event_timestamp format a28
SQL>
SQL> select event_name, to_char(event_date, 'DD-MON-YY HH24:MI:SS') event_date,
2 event_timestamp
3 from company_events
4 /
EVENT_NAME EVENT_DATE EVENT_TIMESTAMP
---------------------------- ------------------ ----------------------------
Name 1 09-SEP-06 16:12:40 09-SEP-06 04.12.40.000000 PM
SQL>
SQL>
SQL> drop table company_events;
Table dropped.
SQL>
SQL>