TIMESTAMP specifies a precision for the SECONDS field in a TIMESTAMP column (the DATE data type can only store whole seconds).
SQL>
SQL> create table other_MyTable (
2 event_name varchar2( 100 ),
3 event_date date,
4 event_timestamp timestamp );
Table created.
SQL>
SQL> insert into other_MyTable( event_name, event_date, event_timestamp ) values( 'A', sysdate, sysdate );
1 row created.
SQL>
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, event_timestamp
2 from other_MyTable;
EVENT_NAME EVENT_DATE EVENT_TIMESTAMP
---------------------------- ------------------ ----------------------------
A 10-JUN-08 17:06:23 10-JUN-08 05.06.23.000000 PM
SQL>
SQL> drop table other_MyTable;
Table dropped.
Related examples in the same category