hour

datetime

Extracts the hour from a timestamp

Syntax

hour(date)

date (timestamp)

The timestamp value to extract the hour from

number

The hour in 24-hour format (0-23)

Input:

hour("2024-03-15 14:30:00")

Output:

Get the current hour

Input:

hour(now())

Output:

Extract hour from a timestamp field

Input:

.timestamp | hour

Output:

The hour() function extracts the hour component from a timestamp value, returning a number from 0 to 23 in 24-hour format.

Use hour() to analyze hourly patterns, filter data by business hours, or group events by time of day.