HOUR

Returns the hour of the day value (24 hour clock) of a DateTime.

Syntax

int? HOUR(DateTime? value)

Example

You can use it with a ModifiedDate column and the function would look like:

HOUR(ModifiedDate)

This would return the hour value of the modified date.