hourofday()

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Returns the integer number representing the hour number of the given date.

Syntax

hourofday(date)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
date	datetime	✔️	The date for which to return the hour number.

Returns

An integer between 0-23 representing the hour number of the day for date.

Example

Run the query

print hour=hourofday(datetime(2015-12-14 18:54))

hour
18