dayofmonth()

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

Provides the day of the month as an integer from a specified datetime value.

Syntax

dayofmonth(date)

Learn more about syntax conventions.

Parameters

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

Returns

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

Examples

The following example shows how to extract the day of the month from a specified datetime value.

Run the query

dayofmonth(datetime(2015-12-14))

Output

result
14