CREATE TABLE MM_END(MM_DATE DATETIME)
INSERT INTO MM_END VALUES ('2001-11-28')
INSERT INTO MM_END VALUES ('2001-11-29')
INSERT INTO MM_END VALUES ('2001-11-30')
INSERT INTO MM_END VALUES ('2001-12-01')
INSERT INTO MM_END VALUES ('2001-12-31')
 
SELECT DATEDIFF(MM, MM_DATE, MM_DATE + 1)
FROM MM_END

/*
----------- 
0
0
1
0
1
*/