Re: oracle date format model

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 02 Jan 2005 22:15:39 GMT
Message-ID: <Xns95D291123EFC6SunnySD@68.6.19.6>

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in news:1104702715.541588.236950_at_c13g2000cwb.googlegroups.com:

> Iana, look again at the Mark's example. He has an explicit to_char
> around the to_date and the format mask for the to_char is 'MM/YY' so
> 02/97 is exactly what should have been returned.
> HTH -- Mark D Powell --
>

OP posted the following:

>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).

^^^^^^^^^^^^

I was/am questioning from where "feb, 1997" was obtained? Received on Sun Jan 02 2005 - 16:15:39 CST