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

Syntax

DAY(@date)

Parameter

•@date: Date to parse