Just set the environment variable before running sqlldr:
export NLS_DATE_FORMAT='MON DD '
"Ruth Gramolini"
We got around this issue but if anyone knows whether this is possible I
would like to know for future reference.
Thanks anyway,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 10, 2002 8:25 AM
> Good morning,
>
> We are ha
Ruth,
If the source file is being loaded with SQL LOADER that you
can format the date load in the controlfile. We get our dates in the MMDD
format and load in to the database default by defining the source
data:
SaleDate TERMINATED BY ","
"TO_DATE(:SALEDATE,'MMDD')",
...Good L
Hello Ruth
The answer is not to change the nls_date_format but to tell the loader the
format you use for your date.
We use the following in our ctl files:
"xx_xx_TAR_NECHONUT date(8) 'MMDD', "
maybe you can use: my_date date(8) 'MMMDD' .
(I did not check if it works).
Yechi
Ruth:
Are you using a delimited flat file via SQL Loader? Would the to_date
function do the trick?
My 0.03 Euro's worth,
Ken
-Original Message-
Sent: Thursday, January 10, 2002 7:25 AM
To: Multiple recipients of list ORACLE-L
Subject:nls_date_format problem in sqlldr
G
Ruth Gramolini wrote:
>
> Good morning,
>
> We are having a problem load a file containing dates in MON DD format
> into a database having and nls_date_format=MMDD. Is there a way to do
> an alter session command in the control file or the parameter file to that
> we can load this data