Temporal Functions

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

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

function current_date() returns date

function current_datetime() returns timestamp

function current_time() returns time

function date($1) returns date

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)

function date_cmp(varchar, varchar) returns bigint

function date_cmp_timestamp(varchar, varchar) returns bigint

function date_cmp_timestampz(varchar, varchar) returns bigint

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)

function date_part_year(varchar) returns bigint

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)

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)

function getdate() returns timestamp

function sysdate() returns date

function timeofday() returns varchar

function timestamp_cmp(varchar, varchar) returns bigint

function timestamp_cmp_date(varchar, varchar) returns bigint

function timestamp_cmp_timestampz(varchar, varchar) returns bigint

function timestampz_cmp(varchar, varchar) returns bigint

function timestampz_cmp_date(varchar, varchar) returns bigint

function timestampz_cmp_timestamp(varchar, varchar) returns bigint

function timezone(varchar, varchar) returns timestamp

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

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