SQL*Loader and Date conversions/masks

Hi all -
[Quoted] I have a table with date fields that default to SYSDATE. I'm trying to [Quoted] load data from SQL Server into the these date fields where the dates [Quoted] look like this:

[Quoted] "2000-11-22 12:28:46.790"

[Quoted] [Quoted] I'd like the dates to be in the format that SYSDATE creates (mmddyyy)

My control file looks like this:

LOAD DATA
INFILE 'd:\data_loads\load.txt'
INTO TABLE demo.test1
[Quoted] FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (id_test1
, date_created date "ddmmmyy"
, date_modified date "ddmmmyy")

The log reports the following:
[Quoted] [Quoted] Record 1: Rejected - Error on table DEMO.TEST1, column DATE_CREATED. [Quoted] ORA-01843: not a valid month

any ideas?

tia
as

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 09 2001 - 19:51:40 CET