SQL> alter session set nls_date_format='FXDD/MM/YY';
Session altered.
SQL> select * from td;
D
--------
01/07/06
01/07/06
01/07/06
01/07/06
15/07/06
05/07/06
30/07/06
01/09/06
01/09/06
01/09/06
10 rows selected.
SQL> select sysdate from dual;
SYSDATE
--------
30/08/06
SQL> insert into td values('01-SEP-2006');
insert into td values('01-SEP-2006')
*
ERROR at line 1:
ORA-01861: literal does not match format string
SQL> insert into td values('01/SEP/2006');
insert into td values('01/SEP/2006')
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
SQL> insert into td values('01/09/2006');
insert into td values('01/09/2006')
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
SQL> insert into td values('01/09/06');
1 row created.
SQL> insert into td values('01-09-06');
insert into td values('01-09-06')
*
ERROR at line 1:
ORA-01861: literal does not match format string
SQL>
Partager