Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Setting date format in Personal Oracle 7
You could try adding this to the init*.ora file:
nls_date_format = "YYYYMMDD"
For temporary changes, try:
alter session set nls_date_format = 'YYYYMMDD';
Greg...
Ceri Moran wrote:
>
> Hi
>
> I am trying to change the date format in PO7 and
> I am not having much luck.
>
> The format at present is '10-JUL-97'.
>
> I wish it to be '19970710' or at the very least '10-JUL-1997'.
>
> Can anyone suggest anything?
>
> Thanks
>
> Ceri Moran
Received on Wed Jul 16 1997 - 00:00:00 CDT
![]() |
![]() |