Oracle bulk loader TIMESTAMP "YYYY-MM-DD HH24:MI:SS.FF6

[bigpoppa]

I am trying to use the ORACLE Bulk Loader stage to generate a ctl for a record layout that contains a timestamp field with the following format: TIMESTAMP "YYYY-MM-DD HH24:MI:SS.FF6". I don't really see a good way to do this b/c the time-spec in the stage is a drop down that doesn't have a format with the 'ff6' option.

Does anyone know how to get around using the drop box for the time format?

Thanks,
BP

[ray.wurlod]

You could switch to user-defined SQL, supplying your own TO_DATE function with appropriate date picture.

Code: Select all

INSERT INTO table(c1,c2,c3) VALUES (:1, :2, TO_DATE(:3, 'YYYY-MM-DD HH24:MI:SS.FF6');