Re: DATE format

You can set the NLS_DATE_FORMAT by:
1. Issuing an ALTER SESSION SET NLS_DATE_FORMAT = 'dd.mm.yyyy' ;

    This may placed in a login script

• OR -- 2. Place the NLS_DATE_FORMAT = 'dd.mm.yyyy' in the init.ora file
• OR -- 3. Set the NLS_TERRITORY for Germany
• OR -- 4. Place a "TO_DATE(...,'dd.m.yyyy')" on the insert statement.

Read up on the NLS_.. paramters in the Oracle Server Reference manual. Ther are many ways to accomplish what you seem to want, it just depends on what you need for this specific case. It won't do to change the overall date format default for entire database instance via the init.ora file if the ned exists only for a "once a week" job.

HTH
    James

In article <7hrun3$6kj$1_at_news.hamburg.pop.de>,   "Susanne Mainz" <susannemainz_at_hotmail.com> wrote:
> Hi everybody,
>
> how can I change the DATE format, so I can do my inserts using the
regular
> German format, e.g. '01.05.1854'? The only format I can use now is
> 'dd-mon-yy'...
>
> thanx
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 20 1999 - 08:08:40 CDT