Set datetime to null Bigquery

user_1059860 0
Viewed 745

How does one set a column with datatype datetime to null?

I searched through the docs and I couldn't find something towards that.

Any suggestions?

google-bigquery
1 Answers

Check if this column is NULLABLE. If it is - just use UPDATE statement:

UPDATE mytable
SET mycolumn = NULL
WHERE myconditions

If it is REQUIRED - you can change REQUIRED to NULLABLE - link

enter image description here

user_134735250
Related