Can upload csv data into bigquery

Question

I try all the time to upload this csv into google Bigquery but I get always a error.

Error while reading data, error message: CSV table encountered too many errors, giving up. Rows: 303; errors: 1. Please look into the errors[] collection for more details. Error while reading data, error message: Invalid time zone: PM; Could not parse '09/09/2006 11:45:00 PM' as datetime for field DATE (position 2) starting at location 71061

---

Its this csv file. I get the error above.

https://ibm.box.com/shared/static/svflyugsr9zbqy5bmowgswqemfpm1x7f.csv

Answer 1

BigQuery dates must be in full ISO standard and UTC,

2019-12-31 00:00:00

Answer 2

DATE time must be in the format of 0001-01-01 00:00:00.

You can load CSV into a temporary file with this field as a string and then using a parse query you can load into your target table