Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date format in Oracle8
If you want to change the date format for the entire database then goto
the initora.ora file a look for NLS_DateFormat.
Or you can change the date format for a session. Use Alter Session command for that.
Bashar Ahmed Amin wrote:
> Hi there,
> How to change the default date format in Oracle8 from DD-MM-YY
> to DD-MM-YYYY??
>
> Thanks,
> Bashar Amin.
Received on Sun May 09 1999 - 14:11:49 CDT
![]() |
![]() |