set NLS_DATE_FORMAT to DD-MON-YYYY but still get invalid date
768724May 26 2010 — edited May 26 2010OS: Windows Server 2003
DB: 11g Production
NLS_TERRITORY: INDONESIA
NLS_LANGUAGE: INDONESIAN
NLS_DATE_FORMAT: DD-MON-YYYY (set during db creation in DBCA, override default)
i have a table called PR:
id number(6) primary key;
issue_date date;
(other columns not important here).
now i do:
insert into PR values (1,'15-MAY-2010');
i got an error. ORA-01858. non-numeric found where numeric was expected.
i tried: insert into PR values (1,'15/05/2010') . it worked. this is the default date format for indonesia.
how can this be? i already set nls_date_format to DD-MON-YYYY.
i did select * from nls_database_parameters, it says NLS-DATE_FORMAT = DD-MON-YYYY