inserting date with sql*loader

[rejoe]

Hello,

I am trying to load data into a table but am getting this error.

ora-01841 :full year must be between -4713 and +9999 and not be 0

The data to be loaded is in a large .csv file and the dates are of the format 22/11/98 00:00:00 but when the loader get to
31/5/00 00:00:00 it gives the error message.

Is there a setting i have to set to enable the insertion of 00 dates.

thanks

RJ

[Chandra]

try this

timestamp DATE "DD/MM/YY HH:MI:SS"

Good Luck