sqlloader and date masks

From: <louburr1_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 15:28:20 GMT
Message-ID: <7dteu9$ukv$1@nnrp1.dejanews.com>

I need to load a file in to oracle the data looks like this:

CDX375XXXXX ,Nov 23 1988 12:00:00:000AM,,Nov 3 1998 12:00:00:000AM ,90000

the first column contains the acct #
the second column contains a date and time. this is my problem. how do you create a mask for the date and tell sqlloader to ignore the time?

the file is comma delimited and varys in lenght so I cant pluck out the date by position.

The acutal files I need to load are huge so I perfer not to write a sed program to strip out the time portion if sql loader can do it directly. Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 09:28:20 CST