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.