Douglas Toltzman <doug(at)oakstreetsoftware(dot)com> writes:
> 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
Thanks --- looks like we'd better change it. I'll work on it later today.
regards, tom lane