| HELP! sql*loader control file - date formatting [message #73940] |
Thu, 05 August 2004 17:13  |
Vanessa
Messages: 5
Registered: October 2001
|
Junior Member |
|
|
Hi -
I'm in desparate need of some help with my control file for SQL*Loader. I'm loading data into a date field and it's giving me an error that I'm trying to insert a non-numeric value into a numeric field. I also need to specify to make the field null if there's no value for the date field. Here's what I have and it say's it's missing a comma:
PROG_START_DT "to_date(:PROG_START_DT, 'M/D/YYYY H:MM:SS') NULLIF PROG_START_DT=BLANKS",
PLEASE HELP!
Thanks!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
