DAY( datetime )
Returns an integer representing the DAY from a given datetime.
Remarks
This is the same as using DATEPART( dd, date )
Example
Output: 28
Output: 4, 28, 2007
SELECT MONTH('4/28/2007'), DAY('4/28/2007'), YEAR('4/28/2007')
SELECT DAY('4/28/2007')