Date & Time Functions

`add_months`

Supported Signatures

function add_months(string, bigint) returns timestamp

🔗 Official Documentation

`convert_timezone`

Returns the input timestamp converted from source timezone to a destination timezone Supported Signatures

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)

🔗 Official Documentation

`date_from_parts`

Construct a date from individual components Supported Signatures

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

🔗 Official Documentation

`date_part`

Supported Signatures

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)

🔗 Official Documentation

`date_trunc`

Supported Signatures

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)

🔗 Official Documentation

`dateadd`

Supported Signatures

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)

🔗 Official Documentation

`datediff`

Supported Signatures

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)

🔗 Official Documentation

`day`

Supported Signatures

function day($1) returns bigint

🔗 Official Documentation

`dayname`

Supported Signatures

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

🔗 Official Documentation

`dayofmonth`

Supported Signatures

function dayofmonth($1) returns bigint

🔗 Official Documentation

`dayofweek`

Supported Signatures

function dayofweek($1) returns bigint

🔗 Official Documentation

`dayofweekiso`

Supported Signatures

function dayofweekiso($1) returns bigint

🔗 Official Documentation

`dayofyear`

Supported Signatures

function dayofyear($1) returns bigint

🔗 Official Documentation

`extract`

Supported Signatures

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)

🔗 Official Documentation

`hour`

Supported Signatures

function hour($1) returns bigint

🔗 Official Documentation

`last_day`

Supported Signatures

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)

🔗 Official Documentation

`minute`

Supported Signatures

function minute($1) returns bigint

🔗 Official Documentation

`month`

Supported Signatures

function month($1) returns bigint

🔗 Official Documentation

`monthname`

Supported Signatures

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

🔗 Official Documentation

`months_between`

Supported Signatures

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

🔗 Official Documentation

`next_day`

Supported Signatures

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

🔗 Official Documentation

`previous_day`

Supported Signatures

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

🔗 Official Documentation

`quarter`

Supported Signatures

function quarter($1) returns bigint

🔗 Official Documentation

`second`

Supported Signatures

function second($1) returns bigint

🔗 Official Documentation

`time_from_parts`

Construct a time from individual components Supported Signatures

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

🔗 Official Documentation

`time_slice`

Supported Signatures

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)

🔗 Official Documentation

`timeadd`

Supported Signatures

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)

🔗 Official Documentation

`timediff`

Supported Signatures

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)

🔗 Official Documentation

`timestamp_from_parts`

Construct a timestamp from individual components Supported Signatures

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

🔗 Official Documentation

`timestampadd`

Supported Signatures

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)

🔗 Official Documentation

`timestampdiff`

Supported Signatures

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)

🔗 Official Documentation

`trunc`

truncate the fractional or date part Supported Signatures

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

🔗 Official Documentation

`week`

Supported Signatures

function week($1) returns bigint

🔗 Official Documentation

`weekiso`

Supported Signatures

function weekiso($1) returns bigint

🔗 Official Documentation

`weekofyear`

Supported Signatures

function weekofyear($1) returns bigint

🔗 Official Documentation

`year`

Supported Signatures

function year($1) returns bigint

🔗 Official Documentation

`yearofweek`

Supported Signatures

function yearofweek($1) returns bigint

🔗 Official Documentation

`yearofweekiso`

Supported Signatures

function yearofweekiso($1) returns bigint

🔗 Official Documentation

​add_months

​convert_timezone

​date_from_parts

​date_part

​date_trunc

​dateadd

​datediff

​day

​dayname

​dayofmonth

​dayofweek

​dayofweekiso

​dayofyear

​extract

​hour

​last_day

​minute

​month

​monthname

​months_between

​next_day

​previous_day

​quarter

​second

​time_from_parts

​time_slice

​timeadd

​timediff

​timestamp_from_parts

​timestampadd

​timestampdiff

​trunc

​week

​weekiso

​weekofyear

​year

​yearofweek

​yearofweekiso

`add_months`

`convert_timezone`

`date_from_parts`

`date_part`

`date_trunc`

`dateadd`

`datediff`

`day`

`dayname`

`dayofmonth`

`dayofweek`

`dayofweekiso`

`dayofyear`

`extract`

`hour`

`last_day`

`minute`

`month`

`monthname`

`months_between`

`next_day`

`previous_day`

`quarter`

`second`

`time_from_parts`

`time_slice`

`timeadd`

`timediff`

`timestamp_from_parts`

`timestampadd`

`timestampdiff`

`trunc`

`week`

`weekiso`

`weekofyear`

`year`

`yearofweek`

`yearofweekiso`