BigQuery Auto-detect date format fails

user_643867 0
Viewed 1572

I have a CSV with dates in the form /mm/dd/yyyy HH:MM:SS AM and I'm trying to import it into BigQuery using AutoDetect.

BigQuery recognizes the field as a date, but then barfs when it tries to interpret AM or PM as a timezone:

Invalid time zone: AM; Could not parse '02/15/2011 07:00:00 AM' as datetime for field Date (position 2) starting at location NNNNNN

google-bigquery format date datetime
1 Answers

That's not a timezone. Try importing as a STRING, then use PARSE_DATE (or PARSE_TIMESTAMP) to parse the STRING values as the desired type.

user_62533470
Related