Call SYSDATE in insert statement : Date « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. Date

SQL>
SQL> create table myTable (
  2  event_name    varchar2( 100 ),
  3  event_date    date );

Table created.

SQL>
SQL>
SQL>
SQL> insert into myTable ( event_name, event_date )
  2  values ( 'Created DATE Sample code', SYSDATE );

1 row created.

SQL>
SQL>
SQL> select * from myTable;


EVENT_NAME                        EVENT_DAT
----------------------------------
Created DATE Sample code          03-JUN-07

SQL> drop table myTable;

Table dropped.