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
*/
Retrieved from http://blog.databaser.net/moniwiki/wiki.php/날짜가해당월의마지막날짜인지판단하기
last modified 2018-04-13 23:12:53