How to cast DATE Column to TIMESTAMP in BigQuery

Solution:

Use the CAST Function CAST(DATE_COLUMN as TIMESTAMP) or just TIMESTAMP(date_column)

#standardSQL\nWITH `project.dataset.table` AS (\n  SELECT CURRENT_DATE() AS dt\n)\nSELECT dt, CAST(dt AS TIMESTAMP) AS ts,\n  TIMESTAMP(dt) AS ts2\nFROM `project.dataset.table`   \n

Result:

Row dt          ts                           ts2\n1   2018-06-13  2018-06-13 00:00:00.000 UTC  2018-06-13 00:00:00.000 UTC       \n

Asran

posted on