Converting to Date while using SQLLoader
This is the value in raw data file: "Oct 31 2012 12:00:00:000AM"
I tried the format "Mon DD YYYY HH:MM:SS:000AM" in the sqlldr control
file, but, that doesn't work. The problem is caused bu the miliseconds. I
tried to use substr, but can't figure out the exact syntax. Also, I am
only interested in the date part and do not need the time part. I can load
this fine as a string but would like to know if there is a trick to
directly load it.
No comments:
Post a Comment