Re: Personal Oracle 7.3 nls_date_format

Session level NLS_DATE_FORMAT value overrides the instance level value.

When you make the connection from the client to the server, the client implicitly sends an ALTER SESSION to set the language/territory setting for that session. This overrides the nls_date_format setting set via init.ora, as Oracle picks up the default nls_date_format for the new territory.

Solution: Add NLS_DATE_FORMAT in the Win95 registry with the required format.

-sm

On 14 Sep 1997 12:14:53 GMT, trwi_at_perth.dialix.com.au (Trevor Williams) wrote:

>Setting nls_date_format = "yyyy/mm/dd" in init.ora
>works fine under UNIX
>but seems to have no effect in PO7.3 under win95.
>Setting the format using alter session ... works fine however.
>
>I will appreciate finding out how to globally set this parameter.
>
>Thanks
>Trevor
>
Received on Wed Sep 17 1997 - 00:00:00 CDT