SELECT knowledge FROM sql_resources WHERE category='bigquery-standard-sql' AND slug='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.

date_utcdate_sydneydate_plus_8
2021-02-122021-02-122021-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.
  • CURRENT_DATETIME
  • CURRENT_TIMESTAMP
CURRENT_DATE([time_zone])
Loading code...