dayofmonth()

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

Returns an integer representing the day number of the given datetime.

Syntax

dayofmonth(date)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
date	datetime	✔️	The datetime used to extract the day number.

Returns

An integer representing the day number of the given datetime.

Example

Run the query

dayofmonth(datetime(2015-12-14))

Output

result
14