How DATE datatpe can store "YYYYMMDD" ?
HI ALl,
In my environment , nls_date_format is DD-MON-RR. So it wont allow me to insert the data value as "YYYYMMDD".
I know that if I change the nls_date_formant as session / system then it will allow me.
But I would like to know what setting I can do with DATE dataype ..so that It should allow the date to be entered in that format ?
insert into tab values ('20130530');
insert into tabvalues ('20130530')
*
ERROR at line 1:
ORA-01861: literal does not match format string
In my environment , nls_date_format is DD-MON-RR. So it wont allow me to insert the data value as "YYYYMMDD".
I know that if I change the nls_date_formant as session / system then it will allow me.
But I would like to know what setting I can do with DATE dataype ..so that It should allow the date to be entered in that format ?
insert into tab values ('20130530');
insert into tabvalues ('20130530')
*
ERROR at line 1:
ORA-01861: literal does not match format string
0