데이타베이스/MYSQL
MySQL 기간 검색 하루, 일주일, 한달
유키공
2020. 4. 29. 17:31
하루
SELECT * FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 DAY ) AND NOW();
일주일
SELECT * FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 WEEK ) AND NOW();
한달
SELECT * FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 MONTH ) AND NOW();