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".