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
Oracle bulk loader TIMESTAMP "YYYY-MM-DD HH24:MI:SS.FF6
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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');
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.