Re: BUG #2885: to_char function

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the OLAP option
JServer Release 9.2.0.4.0 - Production

select ordh_dtinral, to_char(ordh_dtinral,'CC YY') from ordheader
where ordh_dtinral between '01-Jan-2000' and '01-Mar-2000';


ORDH_DTIN TO_CH
--------- -----
05-JAN-00 20 00
05-JAN-00 20 00
05-JAN-00 20 00
05-JAN-00 20 00
05-JAN-00 20 00
05-JAN-00 20 00
05-JAN-00 20 00
05-JAN-00 20 00
06-JAN-00 20 00
06-JAN-00 20 00
06-JAN-00 20 00

(results truncated)



On Jan 12, 2007, at 3:12 PM, Tom Lane wrote:

> Bruce Momjian <bruce@momjian.us> writes:
>> I updated our documentation for CC:
>>         <entry>century component of year (minimum 2 digits)</entry>
>
> Updating the documentation isn't a solution; either the code is
> correct
> or it's not, and I rather suspect it's not (it's incompatible with
> EXTRACT(CENTURY) for example).  Can someone check Oracle's behavior?
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that
> your
>        message can get through to the mailing list cleanly

Douglas Toltzman
doug@oakstreetsoftware.com
(910) 526-5938