The data is the same in either case, you are just talking about the display.
1. look up nls_date_format
2. use to_char(theField,'dd-mmm-yyyy')
Jim
"Flex" <flexNOSP_at_Mfreemail.it> wrote in message
news:tvgq8.51076$S52.1744419_at_news2.tin.it...
> I have a Scheme in Oracle 8i , and I want to change date format.
> Now when , for example ,I do : Select SYSDATE from DUAL ;
> I obtain 02-apr-2002 , I'd like that system return 02-04-2002.
> How can I obtain this ?
>
> Hello
> Flex
>
> P.S. Excuse me 4 my bad English !!!
>
>
Received on Tue Apr 02 2002 - 07:22:50 CST
