How to insert some date types with SQLLoader?
Posted on 2014-11-10
I have some files with different kinds of data and each file type has different date-time field. I want to load those files with SQLLoader to Oracle tables. In each related Oracle table, there is a field with Date type. However, in the files, representation of date-time fields differs according to file type. For example one file type has a date-time field with data sample: "2014-11-10 01:07:57". I'will use YYYY-MM-DD HH24:MI:SS for this in control file. Unfortunately not all file types are easy like this. (See Below) Could you please help for the following?
2014-11-09 04:00:00 AM
Thanks in Advance.