CURRENT_TIMESTAMP

CURRENT_TIMESTAMP function. Definition, syntax, examples and common errors using BigQuery Standard SQL. The CURRENT_TIMESTAMP function returns the date and time at the moment the query is evaluated.

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

Got a CSV?
See it differently in <2 mins

Get started for FREEWatch our CEO do it