Re: oracle date format model

From: Mark Bole <makbo_at_pacbell.net>
Date: Sun, 02 Jan 2005 22:33:18 GMT
Message-ID: <OE_Bd.6307$yV1.1090@newssvr14.news.prodigy.com>

IANAL_VISTA wrote:

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

[...]
> 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?
>
>

I assumed it was not meant to be the literal output, but rather a parenthetical colloquiality to support the main point, namely that there was no error despite the documentation's claim that there would be one.

-Mark Bole Received on Sun Jan 02 2005 - 16:33:18 CST