Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Converting "MM/DD/YYYY" in an inported file to a valid Oracle date.
We are interested on knowing how to convert a string character with a format of "MM/DD/YYYY" that is being imported from an external source into a valid Oracle date field when running SQL*LOADER. Is there a function or a routine we could use in the control file? Received on Mon Feb 02 1998 - 00:00:00 CST