Mega Code Archive
Use timestamp as table column type and insert sysdate to it
<![CDATA[
SQL>
SQL> create table events (
2 event_name varchar2( 100 ),
3 event_date date,
4 event_timestamp timestamp )
5 /
Table created.
SQL>
SQL>
SQL> insert into events ( event_name, event_date, event_timestamp )
2 values ( 'COMPANY_EVENTS table', sysdate, sysdate );
1 row created.
SQL>
SQL>
SQL> column event_name format a28
SQL> column event_date format a18
SQL> column event_timestamp format a28
SQL>
SQL>
SQL> select event_name, to_char(event_date, 'DD-MON-YY HH24:MI:SS') event_date,event_timestamp
2 from events;
EVENT_NAME EVENT_DATE EVENT_TIMESTAMP
---------------------------- ------------------ ----------------------------
COMPANY_EVENTS table 10-JUN-08 21:03:00 10-JUN-08 09.03.00.000000 PM
SQL>
SQL> drop table events;
Table dropped.
SQL>
SQL>
]]>