SQL Resources/BigQuery/CURRENT_DATE

CURRENT_DATE

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.

Syntax

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
date_utc
2021-02-12
date_sydney
2021-02-12
date_plus_8
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 NULL the function returns NULL.

Related Pages

Try a better way to write SQL in BigQuery
Write SQL together with Count.
Try a better way to write SQL in BigQuery
Write SQL together with Count.