Importing datetime fields in "m/dd/yyyy" format using PostgreSQL COPY command
I'd recommend always using ISO date format for any kind of data interchange.

Consider Google's Crush Tools convdate for a quick fix:

  convdate --delim ',' --field 1 --preserve_header --input_format '%m/%d/%Y %I:%M:%S' --output_format '%Y-%m-%dT%H:%M:%S' &lt; myData.csv |
  psql -c '\copy foo from stdin with (format csv, header true)'


0:00:00 is probably not a valid time though. Use csvquote if your data has embedded commas or newlines.