Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with date format !!!! urgent
On Tue, 12 Jun 2007 09:47:04 -0700, News <Contact_404_at_hotmail.com>
wrote:
>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 ?
Which problem? Something which is working as designed?
-- Sybrand Bakker Senior Oracle DBAReceived on Tue Jun 12 2007 - 13:44:49 CDT
![]() |
![]() |