이번달의 날짜를 모두 출력해야할 경우
SELECT
Z.THIS_MONTH_DAY AS THIS_MONTH_DAY
FROM
(
SELECT
LAST_DAY(NOW()) - INTERVAL (A.a + (10 * B.a) + (100 * C.a)) DAY AS THIS_MONTH_DAY
FROM
(select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all
select 5 union all select 6 union all select 7 union all select 8 union all select 9) as A
cross join
(select 0 as a union all select 1 union all select 2 union all select 3 union all select 4
union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as B
cross join
(select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all
select 5 union all select 6 union all select 7 union all select 8 union all select 9) as C
) Z
WHERE
Z.THIS_MONTH_DAY between CONCAT(DATE_FORMAT(NOW(),'%Y-%m'),'-01') and LAST_DAY(NOW())
ORDER BY Z.THIS_MONTH_DAY ASC
참조하여 사용하려 했으나 오늘날짜까지만 출력이 되어 커스터마이징
오늘날짜까지만 출력해야 한다면 하단 링크 참조
참조한곳 :