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() 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.
Truly collaborative analytics platform
Count redefines how data teams plan, build and share their analysis. It's Miro, but for data.
Discover the most flexible SQL editor
Count redefines how analysts plan, build, and share their analysis. It's Miro, but for data.
Become a SQL Expert
Get five free SQL lessons from Count's Head of Data, Taylor Brownlow.