HOUR

Returns the hours portion of the specified date value.

Syntax

HOUR(dateval)

Example

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

HOUR({{mydatefield}})

returns: 09

Related

YEAR
MONTH
DAY
MINUTE
SECOND