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: News <Contact_404_at_hotmail.com>
Date: Wed, 13 Jun 2007 14:27:25 -0700
Message-ID: <1181770045.919835.132130@z28g2000prd.googlegroups.com>


On 12 juin, 21:22, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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.

the value must be surrounded by double quotation marks. For example:

NLS_DATE_FORMAT = "MM/DD/YYYY" http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1116.htm

The format is valid, I tried different ones. they work otherwise I wouldn't get:

SQL> show parameter nls_date_format

nls_date_format                      string      YYYY-MM-DD

I'm not convinced but any answer to this trevious ridiculous problem. Neither by the one given by Sybrand Bakker

the only solution is the one I have given using trigger on logon to database Received on Wed Jun 13 2007 - 16:27:25 CDT

Original text of this message

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