monthofyear()

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

Returns the integer number from 1-12 representing the month number of the given year.

The monthofyear() and getmonth() functions are equivalent

Syntax

monthofyear(date)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
date	datetime	✔️	The date for which to find the month number.

Returns

An integer from 1-12 representing the month number of the given year.

Example

Run the query

print result=monthofyear(datetime("2015-12-14"))

Output

result
12