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_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
NULL
the function returnsNULL
.
Related Pages
- CURRENT_DATE
- CURRENT_TIMESTAMP
CURRENT_DATETIME([time_zone])
Loading code...