MONTH

Returns an integer that represents the month of the specified date.

Syntax

MONTH ( date )

Arguments

date

Is an expression that can be resolved to a time, date, smalldatetime, datetime, datetime2, or datetimeoffset value. The date argument can be an expression, column expression, user-defined variable, or string literal.

Return types

int

Example

SELECT MONTH('2017-04-24T11:44:23.1234567');

See Also