Re: Change Data format in a Scheme

"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 !!!

alter session set nls_date_format='dd-mm-yyyy' in sql*plus or set the registry variable nls_date_format in hklm\software\oracle to this value (NT/windoze)
or set the env var NLS_DATE_FORMAT to this value. You don't provide any detail about your environment, please always do so, in order for the answer to be more appropiate.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Apr 02 2002 - 08:26:42 CST