SQL>
SQL>
SQL> create table myTable (ts timestamp);
Table created.
SQL>
SQL> insert into myTable values (sysdate);
1 row created.
SQL>
SQL> select * from myTable;
TS
------------------------------------------------------
26-OCT-09 08.31.47.000000 AM
1 row selected.
SQL>
SQL> drop table myTable ;
Table dropped.
SQL>