Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> oracle date format model
There is such a statement made by the oracle9i documentation (under Format
model of SQL Reference):
***quote:***
Oracle returns and error if an alphanumeric character is found in the date
string where punctuation character is found in the format string. For
example:
TO_CHAR(TO_DATE('0297', 'MM/YY'), 'MM/YY') returns an error.
select TO_CHAR(TO_DATE('0297', 'MM/YY'), 'MM/YY') from dual
and there is no error returned. Instead the date is displayed properly (feb, 1997).
What is meant by the above statement? Received on Fri Dec 31 2004 - 17:10:31 CST