你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn

monthofyear()

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft 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