Check Date format before inserting : 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> show parameters nls_date_format


NAME_COL_PLUS_SHOW_PARAM                                                         TYPE
-------------------------------------------------------------------------------- -----------
VALUE_COL_PLUS_SHOW_PARAM
---------------------------------
nls_date_format                                                                  string

SQL> insert into myTable ( event_name, event_date )
  2  values ( 'Created an Oracle9i DATE value', DATE '2001-10-11' )
  3  /

1 row created.

SQL> select * from myTable;
 /

EVENT_NAME                           EVENT_DAT
-------------------------------------
Created an Oracle9i DATE value       11-OCT-01

SQL> drop table myTable;

Table dropped.