Date & Time Functions

function add_months(string, bigint) returns timestamp

function convert_timezone $1(varchar, varchar, $1) returns timestamp
	where $1 in (timestamp, string)
function convert_timezone $1(varchar, $1) returns timestamp
	where $1 in (timestamp, string)

function date_from_parts(decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns date

function date_part $1(string, $1) returns decimal(9, 0)
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, dayofweek, weekday, dow, dw, dayofweekiso, weekday_iso, dow_iso, dw_iso, dayofyear, yearday, doy, dy, week, w, wk, weekofyear, woy, wy, weekiso, week_iso, weekofyeariso, weekofyear_iso, quarter, q, qtr, qtrs, quarters, yearofweek, yearofweekiso, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds, epoch_second, epoch, epoch_seconds, epoch_millisecond, epoch_milliseconds, epoch_microsecond, epoch_microseconds, epoch_nanosecond, epoch_nanoseconds, timezone_hour, tzh, timezone_minute, tzm)
	where $1 in (date, time, timestamp, varchar)

function date_trunc(string, date) returns date
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
function date_trunc(string, time(n)) returns time(n)
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
function date_trunc(string, timestamp(n)) returns timestamp(n)
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)

function dateadd $1(string, double, $1) returns $1
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
	where $1 in (date, time, timestamp, varchar)

function datediff $1, $2(string, $1, $2) returns bigint
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
	where $1 in (date, time, timestamp, varchar)
	and $2 in (date, time, timestamp, varchar)

function day($1) returns bigint

function dayname $1($1) returns varchar
	where $1 in (date, string)

function dayofmonth($1) returns bigint

function dayofweek($1) returns bigint

function dayofweekiso($1) returns bigint

function dayofyear($1) returns bigint

function extract $1(string, $1) returns double
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, dayofweek, weekday, dow, dw, dayofweekiso, dayofweek_iso, weekday_iso, dow_iso, dw_iso, dayofyear, yearday, doy, dy, week, w, wk, weekofyear, woy, wy, weekiso, week_iso, weekofyeariso, weekofyear_iso, quarter, q, qtr, qtrs, quarters, yearofweek, yearofweekiso, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds, epoch_second, epoch, epoch_seconds, epoch_millisecond, epoch_milliseconds, epoch_microsecond, epoch_microseconds, epoch_nanosecond, epoch_nanoseconds, timezone_hour, tzh, timezone_minute, tzm)
	where $1 in (date, time, timestamp, varchar)

function hour($1) returns bigint

function last_day $1($1) returns date
	where $1 in (date, time, timestamp, varchar)
function last_day $1($1, string) returns date
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
	where $1 in (date, time, timestamp, varchar)

function minute($1) returns bigint

function month($1) returns bigint

function monthname $1($1) returns varchar
	where $1 in (date, string)

function months_between $1($1, $1) returns bigint
	where $1 in (date, time, timestamp, varchar)

function next_day $1($1, varchar) returns date
	where $1 in (date, string)

function previous_day $1($1, varchar) returns date
	where $1 in (date, string)

function quarter($1) returns bigint

function second($1) returns bigint

function time_from_parts(decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns time
function time_from_parts(decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns time

function time_slice $1($1, bigint, string) returns $1
	where $1 in (date, time, timestamp, varchar)
function time_slice $1($1, bigint, string, string) returns $1
	where $1 in (date, time, timestamp, varchar)

function timeadd $1(string, double, $1) returns $1
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
	where $1 in (date, time, timestamp, varchar)

function timediff $1(string, $1, $1) returns bigint
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
	where $1 in (date, time, timestamp, varchar)

function timestamp_from_parts(decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns timestamp
function timestamp_from_parts(decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns timestamp
function timestamp_from_parts(decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), decimal(38, 0), varchar) returns timestamp
function timestamp_from_parts(date, time) returns timestamp

function timestampadd $1(string, double, $1) returns $1
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
	where $1 in (date, time, timestamp, varchar)

function timestampdiff $1(string, $1, $1) returns bigint
	where string in (year, y, yy, yyy, yyyy, yr, years, yrs, month, mm, mon, mons, months, day, d, dd, days, dayofmonth, week, w, wk, weekofyear, woy, wy, quarter, q, qtr, qtrs, quarters, hour, h, hh, hr, hours, hrs, minute, m, mi, min, minutes, mins, second, s, sec, seconds, secs, millisecond, ms, mesc, milliseconds, microsecond, us,, usec,, microseconds, nanosecond, ns, nsec, nanosec, nsecond, nanoseconds, nanosecs, nseconds)
	where $1 in (date, time, timestamp, varchar)

function trunc(decimal(38, 0)) returns decimal(38, 0)
function trunc(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function trunc(double) returns double
function trunc(double, double) returns double
function trunc(date, varchar) returns date
function trunc(time, varchar) returns time
function trunc(timestamp, varchar) returns timestamp

function week($1) returns bigint

function weekiso($1) returns bigint

function weekofyear($1) returns bigint

function year($1) returns bigint

function yearofweek($1) returns bigint

function yearofweekiso($1) returns bigint