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 dateDate 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 updated
Was this helpful?
