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