I am trying to create a table into BigQuery by importing a file. In that file the date-time format is like this 4/12/2016 12:00:00 AM. BigQuery is not creating a table because of AM. To change that format I tried spreadsheet but it couldn't handle it because the dataset is large. What other options do I have so that I can import that data into BigQuery.

CodePudding user response：

Expounding on Jiho Choi's answer, you can use the following sample code from this

Loaded in Bigquery:

Then apply the