Re: OPO: FORMAT( DATE, date_format_string )... Bug?...

In article <Dp78AA.IKK_at_news.hawaii.edu>, Alvin Nonaka <xea0005_at_co.honolulu.hi.us> wrote:
>When I typed
> select sysdat from dual;
>I got,
> SYSDATE
> -------
> 01-APR-96
>Then I tried
> select to_char(sysdate,'mm/dd/yy') from dual;
>And got,
> TO_CHAR(SYSDATE,'MM/DD/YY')
> ------------------------------------------------------
> 04/01/96

I was speaking about Oracle Power Objects Basic...

My mistake was in assuming that the DATE function return value was a "Date" value.

It is a string, hence the format function doesn't recognize the output from "DATE" as a "Date" and (properly) formats it as a string.

The above article points in the right direction. If you use SYSDATE instead of DATE in the OPO call, the desired Date formatting is performed.

Thank you,
Peter

-- 
Peter Yamamoto                     
University of Waterloo             MFCF Phone: +1 519-888-4567 x6488
Waterloo, Ontario, Canada N2L 3G1  Home Phone: +1 519-747-5318
Email: PJYamamoto_at_UWaterloo.CA     URL: http://daisy.uwaterloo.ca/~pjyamamo/