Re: help with date format !!!! urgent

From: News <Contact_404_at_hotmail.com>
Date: Tue, 12 Jun 2007 12:19:03 -0700
Message-ID: <1181675943.762901.101600@o11g2000prd.googlegroups.com>

On 12 juin, 15:04, EdStevens <quetico_..._at_yahoo.com> wrote:
> perhaps it would be
> better to look at just setting it system-wide in your initialization
> parameters.
>

the answers were in initial post. I said:

in ini.ora:
NLS_DATE_FORMAT = YYYY-MM-DD SQL> show parameter nls_date_format

nls_date_format                      string      YYYY-MM-DD

> What error does imp show when you say you "can't import because of
> this problem"?

ORA-01847: day of month must be between 1 and last day of month Received on Tue Jun 12 2007 - 14:19:03 CDT