This discussion is archived
3 Replies Latest reply: Feb 8, 2013 7:43 AM by Srini Chavali-Oracle RSS

DATE Mask options

982758 Newbie
Currently Being Moderated
I need to load data from a flat file into an Oracle table via SQL*Loader.

The date fields in the flat file are 14 bytes and will look like 20120207123456 (YYYYMMDDHHMMSS). The HH portion is 24 hour format.

In my control file what Date mask can I use?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points