CURRENT_DATETIME

The BigQuery CURRENT_DATETIME function returns the date and time at the moment the query is evaluated. By default the date time will be in UTC timezone but a specific timezone can be selected.

CURRENT_DATETIME([time_zone])

SELECT
  CURRENT_DATETIME() AS datetime_utc,
  CURRENT_DATETIME('Australia/Sydney') AS datetime_sydney,
  CURRENT_DATETIME('+08:00') AS datetime_plus_8

• The returned data type is a DATETIME.

• The full list of supported timezone names can be found here.

• If the time_zone argument is NULL the function returns NULL.

• CURRENT_DATE

• CURRENT_TIMESTAMP