Returns the month of the year from the date indicated in the @date parameter. It is equivalent to the DATEPART function using the @datepart parameter with the month value.

Syntax

MONTH(@date)

Parameter

•@date: Date to parse