SQL Tutorials
Understanding FROM
Understanding JOIN
Understanding WHERE
Using dates in SQL
Using strings in SQL
SQL Functions
CASE
COUNT
BigQuery Tutorials
Arrays Explained
Data Types
Dates and Times
String Functions Explained
Window Functions Explained
BigQuery Functions
ARRAY_AGG
CASE
CAST
COALESCE
CONCAT
COUNT [DISTINCT]
CURRENT_DATE
CURRENT_DATETIME
CURRENT_TIMESTAMP
DATE_DIFF
DATE_TRUNC
DATETIME_DIFF
DATETIME_TRUNC
EXTRACT
IF
MEDIAN
SUBSTR
TIME_DIFF
TIME_TRUNC
TIMESTAMP_DIFF
TIMESTAMP_TRUNC
UNNEST
Snowflake Tutorials
Histograms
Linear Regression
Moving averages
Pivot Tables
Running Totals
Summary Statistics
Window Functions
SQL Server Tutorials
Data Types
Dates and Times
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