Re: How do I change the format of a date?
From: Biss Is Ignorance <bliss_is_ignorance_at_hotmail.com>
Date: Mon, 18 Dec 2000 22:29:21 +0800
Message-ID: <3a3e4182.0_at_news2.tm.net.my>
Date: Mon, 18 Dec 2000 22:29:21 +0800
Message-ID: <3a3e4182.0_at_news2.tm.net.my>
Hi,
To alter for a session give the command
Alter Session Set Nls_Date_Format = 'mm/dd/yyyy';
This will work only for that session. You can give this command provided you have the appropriate rights to run the alter session command.
To change it permanently across sessions, in the registry (assuming you are working on Windows) change / add the registry entry for NLS_DATE having value mm/dd/yyyy
Hope this helps...
"tirthankara" <tirthankara_at_my-deja.com> wrote in message
news:918u7k$eg2$1_at_nnrp1.deja.com...
> Hello,
>
> How can I change the format of a DATE from 03-JUN-99 to 6/3/1999?
>
> Please help. Thanks.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Dec 18 2000 - 15:29:21 CET