CURRENT_DATE
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.
Definition
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 |
Practical Info
- The returned data type is a
DATE. - The full list of supported timezone names can be found here.
- If the time_zone argument is
NULLthe function returnsNULL.
Related Pages
- CURRENT_DATETIME
- CURRENT_TIMESTAMP
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