SQL Resources/BigQuery/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.

Syntax

CURRENT_TIMESTAMP()
SELECT
  CURRENT_TIMESTAMP() AS now
now
2021-02-12T12:25:58.694Z

Practical Info

  • The returned data type is a TIMESTAMP.

Related Pages

Become a SQL Expert
Get five free SQL lessons from Count's Head of Data, Taylor Brownlow.
Email
Title