Re: help with date format !!!! urgent

From: <fitzjarrell_at_cox.net>
Date: Tue, 12 Jun 2007 12:22:15 -0700
Message-ID: <1181676135.344575.120070@x35g2000prf.googlegroups.com>

On Jun 12, 2:19 pm, News <Contact_..._at_hotmail.com> wrote:
> 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

This is your problem:

NLS_DATE_FORMAT = YYYY-MM-DD It should be written:

NLS_DATE_FORMAT = 'YYYY-MM-DD' The date format is a string.

David Fitzjarrell Received on Tue Jun 12 2007 - 14:22:15 CDT