Re: How do I change nls_date_format?

yet another is to edit the init.ora file or issue an alter session set nls_date_format='yyyy-DD-MON'

James Hanway wrote:

> Another option might be to use the TO_CHAR and TO_DATE functions if all you
> are interested in is changing the format of dates.
>
> James
>
> Peter Bryant wrote:
>
> > How do I change nls_date_format on Oracle 8 for NT. I've set the registry
> > key:
> >
> > HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_DATE_FORMAT
> >
> > and editted the init.ora file.
> >
> > Anyone have any further ideas? Basically, I want it to recognise
> > 'YYYY-MM-DD' with an optional HH24:MM:SS.
> >
> > TIA
> >
> > - Peter Bryant
Received on Mon Jan 10 2000 - 20:39:53 CST