Mega Code Archive
(DATEPART(dd, @date1) = DATEPART(dd, @date2))
3> IF (DATEPART(mm, @date1) = DATEPART(mm, @date2)) AND
4> (DATEPART(dd, @date1) = DATEPART(dd, @date2)) AND
5> (DATEPART(yy, @date1) = DATEPART(yy, @date2))
6> PRINT 'The dates are the same'
7> GO