Time Functions

current_time

Supported Signatures

function current_time() returns time
function current_time(time_zone string) returns time

🔗 Official Documentation

format_time

Supported Signatures

function format_time(string, time) returns string

🔗 Official Documentation

parse_time

Supported Signatures

function parse_time(string, string) returns time

🔗 Official Documentation

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

🔗 Official Documentation

time_add

Supported Signatures

function time_add(time, interval microsecond to hour) returns time

🔗 Official Documentation

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)

🔗 Official Documentation

time_sub

Supported Signatures

function time_sub(time, interval microsecond to hour) returns time

🔗 Official Documentation

time_trunc

Supported Signatures

function time_trunc(time, time_part string) returns time
	where time_part in (microsecond, millisecond, second, minute, hour)

🔗 Official Documentation