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

CURRENT_TIMESTAMP

Definition

The BigQuery CURRENT_TIMESTAMP function returns the date and timestamp at the moment the query is evaluated. The result is returned as UTC.

now
2021-02-12T12:25:58.694Z

Practical Info

  • The returned data type is a TIMESTAMP.
  • CURRENT_DATE
  • CURRENT_DATETIME
CURRENT_TIMESTAMP()
SELECT
  CURRENT_TIMESTAMP() AS now