CURRENT_DATE function. Definition, syntax, examples and common errors using BigQuery Standard SQL. The CURRENT_DATE function returns the date at the time the query is evaluated.
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.
| date_utc | date_sydney | date_plus_8 |
|---|---|---|
| 2021-02-12 | 2021-02-12 | 2021-02-12 |
DATE.NULL the function returns NULL.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