Date Functions

current_date

Supported Signatures

function current_date() returns date
function current_date(string) returns date

🔗 Official Documentation

date

Supported Signatures

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

🔗 Official Documentation

date_add

Supported Signatures

function date_add $1($1, interval) returns $1
	where $1 in (date, timestamp)

🔗 Official Documentation

date_diff

Supported Signatures

function date_diff $1($1, $1, date_part string) returns bigint
	where date_part in (day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
	where $1 in (date, timestamp)

🔗 Official Documentation

date_from_unix_date

Supported Signatures

function date_from_unix_date(bigint) returns date

🔗 Official Documentation

date_trunc

Supported Signatures

function date_trunc $1($1, date_part string) returns $1
	where date_part in (day, week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
	where $1 in (date, timestamp)

🔗 Official Documentation

format_date

Supported Signatures

function format_date $1(string, $1) returns string
	where $1 in (date, timestamp)

🔗 Official Documentation

last_day

Supported Signatures

function last_day $1($1) returns date
	where $1 in (date, datetime)
function last_day $1($1, date_part string) returns date
	where date_part in (week, week(monday), week(tuesday), week(wednesday), week(thursday), week(friday), week(saturday), week(sunday), isoweek, month, quarter, year, isoyear)
	where $1 in (date, datetime)

🔗 Official Documentation

parse_date

Supported Signatures

function parse_date(string, string) returns date

🔗 Official Documentation

unix_date

Supported Signatures

function unix_date(date) returns bigint

🔗 Official Documentation