CURRENT_DATE

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

CURRENT_DATE([time_zone])

SELECT
  CURRENT_DATE() AS date_utc,
  CURRENT_DATE('Australia/Sydney') AS date_sydney,
  CURRENT_DATE('+08:00') AS date_plus_8

• The returned data type is a DATE.

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

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

• CURRENT_DATETIME

• CURRENT_TIMESTAMP