Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: nls_date_language inside loader .bat
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
![]() |
![]() |