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