MONTH (TSQL Function)

Returns the month of the specified date.

Syntax

MONTH ( date )

Arguments

date
is an expression of type date or datetime.

Return Types

Returns int.

Examples

PRINT MONTH('2016-10-04');

The result is:

10