You can add the NLS_DATE_FORMAT='DD/MM/YYYY' on oracle.ini on the client
server or modify the paramter in the init.ora on server.
Ilias Santouridis ¼?¼g©ó$å³¹ <36CD524F.24ADCEC6_at_eurodyn.com>...
>Hi all.
>
>We want to change our database's default date formatting.
>The current format is "DD-MON-YY", which I guess results from
>the value of NLS_TERRITORY which is "AMERICA".
>
>I want to change the date format to "YYYY/MM/DD".
>
>I've tried to change the value of NLS_DATE_FORMAT parameter.
>When I execute :
>
> alter session set NLS_DATE_FORMAT = "YYYY/MM/DD"
>
>the format changes for the current session.
>
>However, I want to make this format the default one for all sessions.
>The manual suggests to make an entry in the init.ora file
>for the NLS_DATE_FORMAT parameter. I included the following entry in
>our database's init.ora file :
>
>nls_date_format="YYYY/MM/DD"
>
>The database was then shutted down and restarted. However, the default
>date format didn't change and remained "DD-MON-YY".
>Any explanations ?
>
>I would like to thank you in advance.
>Ilias
Received on Fri Feb 19 1999 - 09:19:45 CST
