Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help with date format !!!! urgent

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US