CURRENT_DATETIME
CURRENT_DATETIME function. Definition, syntax, examples and common errors using BigQuery Standard SQL. The CURRENT_DATETIME function returns the date and time at the moment the query is evaluated.
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_utc | datetime_sydney | datetime_plus_8 |
|---|---|---|
| 2021-02-12T12:26:04.844546 | 2021-02-12T23:26:04.844546 | 2021-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
NULLthe function returnsNULL.
Related Pages
- CURRENT_DATE
- CURRENT_TIMESTAMP
CURRENT_DATETIME([time_zone])SELECT
CURRENT_DATETIME() AS datetime_utc,
CURRENT_DATETIME('Australia/Sydney') AS datetime_sydney,
CURRENT_DATETIME('+08:00') AS datetime_plus_8