HOUR

Extracts the hour component from a given datetime

Description	The HOUR function extracts and returns the hour component from a given datetime. This is useful for time-based analysis, scheduling, or reporting on time-related data.
Syntax	HOUR(datetime)

1. datetime: The datetime from which you want to extract the hour component.

Example

Table

Event	Event DateTime
Event A	2023-09-10 14:30:45
Event B	2023-08-25 08:15:00
Event C	2023-09-01 21:00:20

Function

HOUR(`Event DateTime`)

Results

HOUR (integer)
14
8
21