Search
K

Date

Date Format

Format date with a custom format.

Expression:

DATE_FORMAT(date: string, format: string)

Return:

formatedString: string

Example of usage:

DATE_FORMAT("2022-05-09", "dd. MM. yyyy")
DATE_FORMAT("2022-05-09", "d. MM. yy")
Return value:
"09. 05. 2022"
"9. 05. 22"

Current Date

Returns the current date as ISO-8601 string.

Expression:

DATE_NOW()

Return:

ISO-8601 date string: string

Example of usage:

DATE_NOW()
Return value:
"2022-05-20" // current date

Date Difference

Returns a difference between two dates in the required time or date format.

Expression:

DATE_DIFF(date1: string, date2: string, format?: string = "seconds")
format_types = (years, months, days, hours, minutes, seconds) || seconds

Return:

{format_types: float}

Example of usage:

DATE_DIFF("2022-05-17", "2021-04-15", "minutes")
Return value:
{"minutes":571680}
Last modified 1yr ago