SELECT knowledge FROM sql_resources WHERE category='bigquery-standard-sql' AND slug='current-datetime'

CURRENT_DATETIME

Definition

The BigQuery CURRENT_DATETIME function returns the date and time at the moment the query is evaluated. By default the date time will be in UTC timezone but a specific timezone can be selected.

datetime_utcdatetime_sydneydatetime_plus_8
2021-02-12T12:26:04.8445462021-02-12T23:26:04.8445462021-02-12T20:26:04.844546

Practical Info

  • The returned data type is a DATETIME.
  • The full list of supported timezone names can be found here.
  • If the time_zone argument is NULL the function returns NULL.
  • CURRENT_DATE
  • CURRENT_TIMESTAMP
CURRENT_DATETIME([time_zone])
Loading code...