sqlldr date data

From: Lukasz Szyrmer <lukasz_at_gate.octava.com.pl>
Date: 29 Sep 2000 16:22:48 GMT
Message-ID: <8r2fko$gk3$2@news.tpi.pl>

Hi,

What is the column definition format for importing dates into oracle from CSV's?

I have a date column looking like this

	...,
	TIMESTAMP "TO_DATE('RR-MM-DD HH:MM:SS')",
	.... 

presumably running the SQL function TO_DATE which should recognize which year the data is in if it is in the format of 00-3-7 00:00:00. But sqlldr claims the date cannot be year 0 even though it can be of the range -4000 to +9999.

What should I tell it to import data like this?

Thanks,
Luke Received on Fri Sep 29 2000 - 11:22:48 CDT