Re: OPO: FORMAT( DATE, date_format_string )... Bug?...
From: Alvin Nonaka <xea0005_at_co.honolulu.hi.us>
Date: 1996/04/01
Message-ID: <Dp78AA.IKK_at_news.hawaii.edu>#1/1
01-APR-96 Then I tried
04/01/96
Date: 1996/04/01
Message-ID: <Dp78AA.IKK_at_news.hawaii.edu>#1/1
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
aloha
ayn
Received on Mon Apr 01 1996 - 00:00:00 CEST