"Jay" <me_at_heyjay.com> wrote in message
news:3b6dnaf4OZpTDkTd4p2dnA_at_speakeasy.net...
> Hi,
>
> Every so often (no real specific amount of time), while
> my database is up and running, the system wide
> date format slips from the format in my init.ora of
> 'YYYY/MM/DD HH24:MI:SS' to the oracle default of
> "dd-mon-yyyy".
>
> Any one ever see this?
>
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
> on linux
>
> [o10]:~> cat /opt/oracle/admin/o10/pfile/init.ora | grep NLS_DAT
> NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS'
>
>
> ps, is there a way to set the NLS_DATE_FORMAT system wide
> while the DB is up?
>
> SQL> alter system set nls_date_format = 'yyyy/mm/dd hh24:mi:ss';
> alter system set nls_date_format = 'yyyy/mm/dd hh24:mi:ss'
> *
> ERROR at line 1:
> ORA-02096: specified initialization parameter is not modifiable with this
> option
>
> Thanks
> Jay
>
>
The best way is to make sure in your sql statements you do to_date(....)
when converting strings to dates. Do not rely on on implicit conversions.
Jim
Received on Wed Jun 23 2004 - 09:35:39 CDT
