Date format ‘2024-01-19T18:33:16.000000000’ not imputing in BigQuery using format – Field ‘date’ has changed type from DATETIME to TIMESTAMP

by

I’m trying to move a dataframe from python, with a date column format as '2024-01-19T18:33:16.000000000' to Bigquery. this column also has NaT values. But while pushing this in BigQuery, i have specified the column schema as ‘DATETIME’, but am getting the following error –

Field ‘date’ has changed type from DATETIME to TIMESTAMP

What is the problem and how should it be solved? current datatype of date column is datetime64[ns]

Also, can someone specify what would the formatting of this date – '2024-01-19T18:33:16.000000000' be like? if i would like to play around with it by converting it to a string?

Leave a Comment