converting Date time column in .DAT file to timestamp with fastload.

Tools & Utilities

converting Date time column in .DAT file to timestamp with fastload.

Hi,
I have a .DAT file with data as "Feb 5 1994 05:15:45:000PM" and trying to load that in teredata using Fastload utility and using the timestamp in the target table with format "MMMbDDbYYYYbHH:MI:SST" .

on doing so all the data is getting populated in the errortable but its returning code as '0' and the fastload is terminated.

i have also tried using the varchar(255) instead of timestamp in the target table and is working.But i need the date and time in the timestamp format only.

i have also tried with timestamp(3) for the milisecond part(i.e.:000PM) it's also working but need it only in HH:MI:SSPM itself.

Any suggestion will help a lot

Thanking You

Regards
Milind