sql*loader question

From: <raju_pillai_at_yahoo.com>
Date: Tue, 19 Oct 1999 11:58:04 GMT
Message-ID: <7uhmc8$5l8$1@nnrp1.deja.com>

I am trying to load a timestamp field from db2 to a date field in oracle. This input file has been exported from a db2 database using export delimited option. The exported file looks like this : 1,test,"1998-03-04-01.23.23.023423","test data"

the third field is a timestamp field, when I try to load this into oracle it does'nt like it. In oracle that field is defined as a date field. How can I load this field into oracle. I tried to use date(26) and giving the picture, it did'nt work. Please help.

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 19 1999 - 06:58:04 CDT