Skip to content Skip to sidebar Skip to footer
Home / Format / Oracle / Sql Loader / Timestamp

Oracle Sqlldr Timestamp Format Headache

Post a Comment
I'm struggling to get sqlldr to import a csv data file into my table, specifically with the field that is a timestamp. The data in my csv file is in this format: 16-NOV-09 01.57.48

Solution 1:

you can try this format:

event_timestamp TIMESTAMP "dd-MON-yy hh.mi.ss.ff6 PM"

You can browse all available formats in the SQL reference documentation.

Post a Comment for "Oracle Sqlldr Timestamp Format Headache"