Database/MySQL
MySQL 특정날짜 사이의 월 목록 가져오기
셋부터넷
2020. 11. 4. 19:27
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
SELECT
DATE_FORMAT(m1, '%Y-%m') AS standardDate
FROM(
SELECT
('2020-01-11' - INTERVAL DAYOFMONTH('2020-01-11')-1 DAY) +INTERVAL m MONTH as m1
FROM(
SELECT @rownum:=@rownum+1 as m FROM
(SELECT 1 union SELECT 2 union SELECT 3 union SELECT 4) t1,
(SELECT 1 union SELECT 2 union SELECT 3 union SELECT 4) t2,
(SELECT 1 union SELECT 2 union SELECT 3 union SELECT 4) t3,
(SELECT 1 union SELECT 2 union SELECT 3 union SELECT 4) t4,
(SELECT @rownum:=-1) t0
) d1
) d2
WHERE m1 <= '2020-09-30'
ORDER BY m1
|
cs |
참고 : stackoverrun.com/ko/q/4011597
mysql에서 두 날짜 사이의 월 목록을 얻는 방법
mysql에서 두 날짜 사이의 월 목록을 가져 왔습니다. For Example:My Input is From date 23-01-2013 To Date 01-04-2014 Output Should be Jan 2013, Feb 2013, March 2013, . . . Jan 2014, Feb 2014, Mar 2014, Apr ...
stackoverrun.com