Bigquery Functions
Date Functions
current_date
Supported Signatures
function current_date() returns date
function current_date(string) returns date
date
Supported Signatures
function date(bigint, bigint, bigint) returns date
function date(timestamp) returns date
function date(timestamp, string) returns date
function date(datetime) returns date
date_add
Supported Signatures
function date_add $1($1, interval) returns $1
where $1 in (date, datetime, timestamp)
date_diff
Supported Signatures
function date_diff $1($1, $1, date_part string) returns bigint
where date_part in (day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
where $1 in (date, datetime, timestamp)
date_from_unix_date
Supported Signatures
function date_from_unix_date(bigint) returns date
date_trunc
Supported Signatures
function date_trunc $1($1, date_part string) returns $1
where date_part in (day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
where $1 in (date, datetime, timestamp)
format_date
Supported Signatures
function format_date $1(string, $1) returns string
where $1 in (date, datetime, timestamp)
last_day
Supported Signatures
function last_day $1($1) returns date
where $1 in (date, datetime)
function last_day $1($1, date_part string) returns date
where date_part in (week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
where $1 in (date, datetime)
parse_date
Supported Signatures
function parse_date(string, string) returns date
unix_date
Supported Signatures
function unix_date(date) returns bigint