HOUR

Extracts the hour component from a given datetime

Updated over a week ago

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)

Output

integer

Variables

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

Example

HOUR(`Event DateTime`)

Event

Event DateTime

HOUR

Event A

2023-09-10T10:30:45000

14

Event B

2023-08-25T04:15:00000

8

Event C

2023-09-01T17:00:20000

21

Did this answer your question?