FormatDateTime

Table of Contents



Parses a date/time value and returns it formatted with a .NET date/time format string. See DateTime for the format specifiers.

String FormatDateTime(String datetime, String format = 'yyyy-MM-dd HH:mm:ss.fff')

round-pushpin Returns 'Thursday, February 29 2024'.
SELECT FormatDateTime('2024-02-29 13:45:00', 'dddd, MMMM d yyyy') as Result FROM Single

round-pushpin Formats the result of DateAdd.
SELECT FormatDateTime(DateAdd(DateTimeUTC(), 'Day', -10), 'yyyy-MM-dd') as TenDaysAgo FROM Single