Bigquery Functions
Time Functions
current_time
Supported Signatures
function current_time() returns time
function current_time(time_zone string) returns time
format_time
Supported Signatures
function format_time(string, time) returns string
parse_time
Supported Signatures
function parse_time(string, string) returns time
time
Supported Signatures
function time(int64, int64, int64) returns time
function time(timestamp) returns time
function time(timestamp, time_zone string) returns time
function time(datetime) returns time
time_add
Supported Signatures
function time_add(time, interval microsecond to hour) returns time
time_diff
Supported Signatures
function time_diff(time, time, date_time_part string) returns bigint
where date_time_part in (microsecond, millisecond, second, minute, hour)
time_sub
Supported Signatures
function time_sub(time, interval microsecond to hour) returns time
time_trunc
Supported Signatures
function time_trunc(time, time_part string) returns time
where time_part in (microsecond, millisecond, second, minute, hour)