Entering the Date Mask in the SQL Loader wizard in Toad is being ignored in the Control File.
Example:
Toad creates the following CTL file when specifying a TIMESTAMP datatype:
INTO TABLE "GEORGE"."TIMES"
INSERT
FIELDS TERMINATED BY ','
(TIME_ID,
CALENDAR_MONTH_DESC,
BIRTHDATE TIMESTAMP,
VALID,
CHECKTIME TIMESTAMP)
Expecting to see the mask in the CTL file:
INTO TABLE "GEORGE"."TIMES"
INSERT
FIELDS TERMINATED BY ','
(TIME_ID,
CALENDAR_MONTH_DESC,
BIRTHDATE TIMESTAMP "dd-MON-yy hh.mi.ss.ff6 PM",
VALID,
CHECKTIME TIMESTAMP "dd-MON-yy hh.mi.ss.ff6 PM")