Re: Date default format

Hello,

    I think you have to look at the NLS parameter on the "client" side not startup parameters to the database.

/Ulf

Rich Chopyak wrote in message <6v0od5$m5m$1_at_news1.rmi.net>...
>Env: Oracle 8, WinNT 4.0
>
>I'm trying to change the default date format to mm/dd/yy and have added the
>line NLS_DATE_FORMAT = "MM/DD/YYYY" to my InitOrcl.ora file, but it doesn't
>seem to recognize the change. When I select a date field, I still get the
>default '10 APR 1993' format.
>
>I've restarted the database and the computer.
>
>Any ideas on what I'm doing wrong would be greatly appreciated.
>
>Rich Chopyak
>rich_at_alpinetg.com
>
>
Received on Fri Oct 02 1998 - 03:35:13 CDT