Re: NLS_DATE_FORMAT

jst <jsp_at_pobox.sk> wrote in message
news:950000332.718461_at_virtual.nextra.sk...
> How can I change NLS_DATE_FORMAT from "DD-mmm-YY" to e.g. "DD.MM.YYYY"? I
> want to insert SYSDATE into a table and see through the SELECT command in
> other format than default. I tried to set NLS_DATE_FORMAT = "DD.MM.YYYY"
in
> init.ora file, or ALTER SESSION SET NLS_DATE_FORMAT = "DD.MM.YYYY" and
> restart, but it does`nt work. I`m using Oracle 8.0.5 on Win NT.
>

the NLS settings are to allow individual users to customise how they see results. To do what you want you would have to set the date format on every client machine, and give all of your users strict instructions never to change it. (I don't know Oracle 8, but in 7.3 you have to edit the registry to change the NLS settings - RTFM) A better approach IMO, if you want to force your users to see a date in a specific format, is to use the TO_CHAR function in all your queries.

Phil. Received on Tue Feb 08 2000 - 05:32:28 CST