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

Home -> Community -> Usenet -> c.d.o.misc -> Re: nls_date_language inside loader .bat

Re: nls_date_language inside loader .bat

From: Gorm <andreas_sandgren_at_hotmail.com>
Date: Mon, 17 Feb 2003 21:14:53 GMT
Message-ID: <hhc4a.598$ID6.1727@newsc.telia.net>


In the control file where you define the order of the columns etc. you could try to add DATE and then the dateformat within double quotes.

It could look like this (with swedish dateformat): ....
varcharcol1,
datecolumn1 DATE "YYYY-MM-DD",
numbercol1,
....

Hope this helps!

//Gorm

"Yolanda Larraona" <ylarraona_at_ibge.gov.br> wrote in message news:473efed6.0302171216.537b4c71_at_posting.google.com...
> Dear all,
> I´m trying to load a archive which
> has english format date,
> but my client is installed with another date language format(portuguese),
> how can I from inside loader .bat tells that I´m loading english
> date format language, because my session expects portuguese date format,
> or if I can´t do that from inside loader .bat,
> how can I solve this,
> thanks in advance,
> yolanda.
Received on Mon Feb 17 2003 - 15:14:53 CST

Original text of this message

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