Re: R: How do I change nls_date_format?

you can change nls_date_format per session: alter session set nls_date_format='yyyy-dd-mm' or edit the init.ora file

GioBra wrote:

> Hi all,
> Can i do the same with Oracle 7.3 ?
>
> Giorgio Bravi
>
> Peter Bryant <pbryant_at_bigfoot.NOSPAM.com> wrote in message
> 946886348.348959_at_shelley.paradise.net.nz...
> > 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 Tue Jan 04 2000 - 01:53:28 CST