FORMAT_DATETIME¶

Description¶

FORMAT_DATETIME takes a datetime value and a format string, and returns the datetime formatted as a human-readable string. The format string uses the same tokens as FORMAT_DATE, with the addition of time tokens.

Token	Meaning	Example
`DD`	Day of the month (zero-padded)	`05`
`MM`	Month number (zero-padded)	`03`
`YYYY`	Four-digit year	`2024`
`hh`	Hour (24-hour clock, zero-padded)	`14`
`mm`	Minutes (zero-padded)	`30`
`ss`	Seconds (zero-padded)	`00`

Example¶

p is Person
FORMAT_DATETIME(p.appointment_datetime, 'DD.MM.YYYY hh:mm')

This returns a string like "05.03.2024 14:30".