Re: help with date format !!!! urgent

From: News <Contact_404_at_hotmail.com>
Date: Tue, 12 Jun 2007 09:47:04 -0700
Message-ID: <1181666824.960501.195190@i13g2000prf.googlegroups.com>

On 12 juin, 17:20, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jun 12, 3:48 am, News <Contact_..._at_hotmail.com> wrote:

> The only sure way to fix this is to recreate your tables with proper
> DEFAULT declarations:
>
> CREATE TABLE HR.T (D DATE DEFAULT to_date('0001-01-01','YYYY-MM-
> DD') NULL);
>

Thanks ! but ..
it's not my database !! I'm trying to clone Oracle Applications HR module database.

The Tables are created this way by Oracle !!!!!!

and the problem remains : why altering nls-date-format works in session level and not in system level in ini.ora ? Received on Tue Jun 12 2007 - 11:47:04 CDT