If your table has a datetime column and you are using either Manual or Autodetect option for upload, it’s important to make sure your column is formatted properly because BigQuery is very sensitive to datetime formatting and it only accepts one of predefined formats. For example trying to upload “4/10/2020 21:18:39” will throw an error.
The supported correct formats are:
- YYYY-MM-DD HH:MM => Example: 2020-03-05 20:00
- YYYY-MM-DD HH:MM:SS => Example: 2020-03-05 20:00:00
- YYYY-MM-DD HH:MM:SS.SSSSSS => Example: 2020-03-05 20:00:00.029300 (time with miliseconds).
Here is how to achieve YYYY-MM-DD HH:MM:SS formatting in Google Sheets: