SQL Loader

Hi,

I have a .CSV file with diffrent fields one of the field is Date( Have data in diffrent date format)
I am try to load but I am face this kin of errors

---- SQL LOADER SCRIPT FILE ---
--options(skip=1)
options(Errors=20000)
load data
infile 'C:\pdxappdb_scripts\fadi_tables\csv\habib_treq_dbs007.csv'    
badfile 'C:\pdxappdb_scripts\fadi_tables\TREQ.bad'
discardfile 'C:\pdxappdb_scripts\fadi_tables\TREQ.dsc'
replace
into table  TREQ_DBS
fields terminated by ',' optionally enclosed by '$'
--fields terminated by '$'
trailing nullcols
(
      REQUESTNO       ,
      SAFETYCODE       CHAR(1000),
      ENVTCODE       CHAR(500),
      SRED             CHAR(500),
      MSDS             CHAR(500),
      CHEMICAL       CHAR(1000),
      MADE             CHAR(1000),
--      CALENDAR_DATE       "to_date (:CALENDAR_DATE, 'yyyy-mm-dd hh24:mi:ss')" ,
      CALENDAR_DATE       "to_date (:CALENDAR_DATE, 'RRRR/MM/DD')",
      REQUESTOR        CHAR(1000),
      CELLTYPE       CHAR(400),
      CELLBATCH       CHAR(1000),
      SUBBATCH       CHAR(400),
      CELLNO             ,
      PRIORITY        ,
      PURPOSE       char(1000),
      NO_OFASSEM       ,
      CATHODE       CHAR(1000),
      ANODE             CHAR(1000),
      ELEC              CHAR(800),
      DESIGN             CHAR(800),
      COND             CHAR(800),
      PERFORM       ,
      SAFETY             ,
      CONDDETAILS       CHAR(800),
      PERFORMDETAILS       CHAR(1800),
      NO_OFCYCLE       ,
      SAFETYDETAILS       CHAR(1800),
      NO_OFABUSE       ,
      DATATECHNICIAN       ,
      COMMENTS       CHAR(800),
      THISTREQ       CHAR(400)
--      EXPERIMENT_ID       ,
--      APPROVED       

)

 
                    ------------------------------

 ----- Errors ------

SQL*Loader: Release 9.2.0.1.0 - Production on Thu Oct 18 16:21:19 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Control File:   C:\pdxappdb_scripts\fadi_tables\TREQ_DBS.txt
Data File:      C:\pdxappdb_scripts\fadi_tables\csv\habib_treq_dbs007.csv
  Bad File:     C:\pdxappdb_scripts\fadi_tables\TREQ.bad
  Discard File: C:\pdxappdb_scripts\fadi_tables\TREQ.dsc
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 20000
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table TREQ_DBS, loaded from every logical record.
Insert option in effect for this table: REPLACE
TRAILING NULLCOLS option in effect

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
REQUESTNO                           FIRST     *   ,  O($) CHARACTER            
SAFETYCODE                           NEXT  1000   ,  O($) CHARACTER            
ENVTCODE                             NEXT   500   ,  O($) CHARACTER            
SRED                                 NEXT   500   ,  O($) CHARACTER            
MSDS                                 NEXT   500   ,  O($) CHARACTER            
CHEMICAL                             NEXT  1000   ,  O($) CHARACTER            
MADE                                 NEXT  1000   ,  O($) CHARACTER            
CALENDAR_DATE                        NEXT     *   ,  O($) CHARACTER            
    SQL string for column : "to_date (:CALENDAR_DATE, 'RRRR/MM/DD')"
REQUESTOR                            NEXT  1000   ,  O($) CHARACTER            
CELLTYPE                             NEXT   400   ,  O($) CHARACTER            
CELLBATCH                            NEXT  1000   ,  O($) CHARACTER            
SUBBATCH                             NEXT   400   ,  O($) CHARACTER            
CELLNO                               NEXT     *   ,  O($) CHARACTER            
PRIORITY                             NEXT     *   ,  O($) CHARACTER            
PURPOSE                              NEXT  1000   ,  O($) CHARACTER            
NO_OFASSEM                           NEXT     *   ,  O($) CHARACTER            
CATHODE                              NEXT  1000   ,  O($) CHARACTER            
ANODE                                NEXT  1000   ,  O($) CHARACTER            
ELEC                                 NEXT   800   ,  O($) CHARACTER            
DESIGN                               NEXT   800   ,  O($) CHARACTER            
COND                                 NEXT   800   ,  O($) CHARACTER            
PERFORM                              NEXT     *   ,  O($) CHARACTER            
SAFETY                               NEXT     *   ,  O($) CHARACTER            
CONDDETAILS                          NEXT   800   ,  O($) CHARACTER            
PERFORMDETAILS                       NEXT  1800   ,  O($) CHARACTER            
NO_OFCYCLE                           NEXT     *   ,  O($) CHARACTER            
SAFETYDETAILS                        NEXT  1800   ,  O($) CHARACTER            
NO_OFABUSE                           NEXT     *   ,  O($) CHARACTER            
DATATECHNICIAN                       NEXT     *   ,  O($) CHARACTER            
COMMENTS                             NEXT   800   ,  O($) CHARACTER            
THISTREQ                             NEXT   400   ,  O($) CHARACTER            

Record 1: Rejected - Error on table TREQ_DBS, column CALENDAR_DATE.        ---  I give just one line
ORA-01847: day of month must be between 1 and last day of month


Table TREQ_DBS:
  165 Rows successfully loaded.
  14406 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                 251064 bytes(12 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:         14571
Total logical records rejected:     14406
Total logical records discarded:        0

Run began on Thu Oct 18 16:21:19 2007
Run ended on Thu Oct 18 16:24:52 2007

Elapsed time was:     00:03:33.76
CPU time was:         00:00:03.50


What Format I need to Load diffrent date format into that Date Field

bye