dayofmonth()

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

dayofmonth(datetime(2015-12-14))

Output

result
14