Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How do I change the format of a date?
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 - 08:29:21 CST