Temporal Functions

add_months

Supported Signatures

function add_months(date, bigint) returns timestamp
function add_months(timestamp, bigint) returns timestamp

🔗 Official Documentation

convert_timezone

Supported Signatures

function convert_timezone(varchar, varchar) returns timestamp
function convert_timezone(varchar, varchar, varchar) returns timestamp

🔗 Official Documentation

current_date

Supported Signatures

function current_date() returns date

🔗 Official Documentation

current_datetime

Supported Signatures

function current_datetime() returns timestamp

🔗 Official Documentation

current_time

Supported Signatures

function current_time() returns time

🔗 Official Documentation

date

Supported Signatures

function date($1) returns date

🔗 Official Documentation

date_add

Supported Signatures

function date_add $1(varchar, bigint, $1) returns date
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, day, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)
	where $1 in (date, timestamp, time, varchar)

🔗 Official Documentation

date_cmp

Supported Signatures

function date_cmp(varchar, varchar) returns bigint

🔗 Official Documentation

date_cmp_timestamp

Supported Signatures

function date_cmp_timestamp(varchar, varchar) returns bigint

🔗 Official Documentation

date_cmp_timestampz

Supported Signatures

function date_cmp_timestampz(varchar, varchar) returns bigint

🔗 Official Documentation

date_part

Supported Signatures

function date_part(varchar, varchar) returns float
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, dayofweek, dow, dw, weekday, dayofyear, doy, dy, yearday, days, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)

🔗 Official Documentation

date_part_year

Supported Signatures

function date_part_year(varchar) returns bigint

🔗 Official Documentation

dateadd

Supported Signatures

function dateadd $1(varchar, bigint, $1) returns date
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, day, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)
	where $1 in (date, timestamp, time, varchar)

🔗 Official Documentation

datediff

Supported Signatures

function datediff $1, $2(varchar, $1, $2) returns bigint
	where varchar in (millennium, millennia, mil, mils, century, centuries, c, cent, cents, decade, decades, dec, decs, year, years, y, yr, yrs, quarter, quarters, qtr, qtrs, month, months, mon, mons, week, weeks, w, day, days, d, hour, hours, h, hr, hrs, minute, minutes, m, min, mins, second, seconds, s, sec, secs, millisecond, milliseconds, ms, msec, msecs, msecond, mseconds, millisec, millisecs, millisecon, microsecond, microseconds, microsec, microsecs, microsecond, usecond, useconds, us, usec, usecs)
	where $1 in (date, timestamp, time with time zone, time, varchar)
	and $2 in (date, timestamp, time with time zone, time, varchar)

🔗 Official Documentation

getdate

Supported Signatures

function getdate() returns timestamp

🔗 Official Documentation

sysdate

Supported Signatures

function sysdate() returns date

🔗 Official Documentation

timeofday

Supported Signatures

function timeofday() returns varchar

🔗 Official Documentation

timestamp_cmp

Supported Signatures

function timestamp_cmp(varchar, varchar) returns bigint

🔗 Official Documentation

timestamp_cmp_date

Supported Signatures

function timestamp_cmp_date(varchar, varchar) returns bigint

🔗 Official Documentation

timestamp_cmp_timestampz

Supported Signatures

function timestamp_cmp_timestampz(varchar, varchar) returns bigint

🔗 Official Documentation

timestampz_cmp

Supported Signatures

function timestampz_cmp(varchar, varchar) returns bigint

🔗 Official Documentation

timestampz_cmp_date

Supported Signatures

function timestampz_cmp_date(varchar, varchar) returns bigint

🔗 Official Documentation

timestampz_cmp_timestamp

Supported Signatures

function timestampz_cmp_timestamp(varchar, varchar) returns bigint

🔗 Official Documentation

timezone

Supported Signatures

function timezone(varchar, varchar) returns timestamp

🔗 Official Documentation

to_date

Supported Signatures

function to_date(varchar, varchar) returns date
function to_date(varchar, varchar, boolean) returns date

🔗 Official Documentation

to_timestamp

Supported Signatures

function to_timestamp(varchar, varchar) returns timestamp
function to_timestamp(varchar, varchar, boolean) returns timestamp

🔗 Official Documentation