Datetime Functions

current_datetime

Supported Signatures

function current_datetime() returns datetime
function current_datetime(string) returns datetime

🔗 Official Documentation

datetime

Supported Signatures

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

🔗 Official Documentation

datetime_add

Supported Signatures

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

🔗 Official Documentation

datetime_diff

Supported Signatures

function datetime_diff $1($1, $1, part string) returns bigint
	where part in (microsecond, millisecond, second, minute, hour, 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

datetime_sub

Supported Signatures

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

🔗 Official Documentation

datetime_trunc

Supported Signatures

function datetime_trunc $1($1, date_time_part string) returns $1
	where date_time_part in (microsecond, millisecond, second, minute, hour, 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_datetime

Supported Signatures

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

🔗 Official Documentation

parse_datetime

Supported Signatures

function parse_datetime(string, string) returns datetime

🔗 Official Documentation