Re: How do I change nls_date

From: James Hanway <hanwayj_at_dfo-mpo.gc.ca>
Date: Thu, 06 Jan 2000 20:38:28 GMT
Message-ID: <3874FD47.9B5730E1@dfo-mpo.gc.ca>

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 Thu Jan 06 2000 - 14:38:28 CST

Re: How do I change nls_date_format?