monthofyear()

  • Article

Applies to: ✅ 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

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

Output

result
12