RE: SQL*Loader and date/time datatypes

Hi Ed,

you could try this syntax for control file. Example:
...

STIME position(52:64) "to_date(substr(:STIME,1,6)||substr (:STIME,8,13),'rrmmddhh24miss')",
...

If you like just a time portion, you should change a format string and remove
the first substr function. But, doing this way you'll get the 1st day of current month in date part.

Regards,

Roman Mirzaitov
Brainbench MVP for Oracle Administration www.brainbench.com Received on Tue Jul 10 2001 - 00:22:02 CDT