with (1) 썸네일형 리스트형 MariaDB - 달력(Calendar) 출력하기 (날짜 주 단위로 출력) 2024년 5월( 2024-05-01 ~ 2024-05-31 ) 날짜 출력WITH RECURSIVE DATE_TEMP AS ( SELECT DATE_FORMAT('2024-05-01', '%Y%m%d') AS DT , WEEKDAY('2024-05-01') AS WEEKDAY , WEEK('2024-05-01') AS WEEK UNION ALL SELECT DATE_FORMAT(DATE_ADD(DATE_TEMP.DT, INTERVAL 1 DAY), '%Y%m%d') AS DT , WEEKDAY(DATE_ADD(DATE_TEMP.DT, INTERVAL 1 DAY)) AS WEEKDAY , WEEK(DATE_ADD(DATE_TEMP.DT, INTERVAL 1 DAY)) AS WEEK FR.. 이전 1 다음
