MySQL에서 특정날짜 사이의 날짜 목록 모두 가져오기
1 2 3 4 5 6 7 8 9 | select * from (select adddate('2010-01-01',t4.i*10000 + t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t0, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t1, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t2, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t3, (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) t4) v where selected_date between '2018-09-10' and '2018-10-31' | cs |
참고 : stackoverflow.com/questions/9295616/how-to-get-list-of-dates-between-two-dates-in-mysql-select-query
How to get list of dates between two dates in mysql select query
I want list of dates lies between two dates by select query. For example: If i give '2012-02-10' and '2012-02-15' I need the result. date ---------- 2012-02-10 2012-02-11 2012-02-12 2012-0...
stackoverflow.com
'Database > MySQL' 카테고리의 다른 글
MySQL 그룹별 시퀀스 번호 지정하기 (0) | 2020.11.18 |
---|---|
MySQL 특정날짜 사이의 월 목록 가져오기 (0) | 2020.11.04 |
MySQL 가로데이터를 세로데이터로 전환하기 (0) | 2020.10.23 |
계층구조 테이블에서 계층쿼리 구현 (0) | 2020.09.17 |