DAY

Returns the day portion of the specified date value.

Syntax

DAY(dateval)

Example

If mydatefield has value '2024-10-30 09:55:00', then:

DAY({{mydatefield}})

returns: 30

Related

YEAR
MONTH
HOUR
MINUTE
SECOND