Re: oracle date format model

<tncc> wrote in news:41d5dc67_3_at_rain.i-cable.com:

> 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.
> *********
> However, I tried:
>
> 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?
>
>
>

How in the world do you get "feb, 1997" returned by a mask of 'MM/YY'?

I suspect your actual mask was 'mon, YYYY' Received on Fri Dec 31 2004 - 18:08:33 CST