Bigquery Functions
Datetime Functions
current_datetime
Supported Signatures
function current_datetime() returns datetime
function current_datetime(string) returns datetime
datetime
Supported Signatures
function datetime(bigint, bigint, bigint, bigint, bigint, bigint) returns datetime
function datetime(date) returns datetime
function datetime(date, time) returns datetime
function datetime(timestamp) returns datetime
function datetime(timestamp, string) returns datetime
datetime_add
Supported Signatures
function datetime_add $1($1, interval) returns $1
where $1 in (datetime, timestamp)
datetime_diff
Supported Signatures
function datetime_diff $1($1, $1, part string) returns bigint
where part in (microsecond, millisecond, second, minute, hour, day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
where $1 in (datetime, timestamp)
datetime_sub
Supported Signatures
function datetime_sub $1($1, interval) returns $1
where $1 in (datetime, timestamp)
datetime_trunc
Supported Signatures
function datetime_trunc $1($1, date_time_part string) returns $1
where date_time_part in (microsecond, millisecond, second, minute, hour, day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
where $1 in (datetime, timestamp)
format_datetime
Supported Signatures
function format_datetime $1(string, $1) returns string
where $1 in (datetime, timestamp)
parse_datetime
Supported Signatures
function parse_datetime(string, string) returns datetime