개발자공간/MYSQL & MARIADB
mysql & mariadb 한달전, 하루전, 한시간전
냉국이
2020. 12. 8. 18:29
728x90
한달전
where reg_date >= date_add(now(), interval -1 month)
하루전
where reg_date >= date_add(now(), interval -1 day)
한시간전
where reg_date >= date_add(now(), interval -1 hour)
---
하루전
SELECT COLUMN1,2.... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 DAY ) AND NOW();
일주일전
SELECT COLUMN1,2.... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 WEEK ) AND NOW();
한달전
SELECT COLUMN1,2.... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 MONTH ) AND NOW();
한달전
where reg_date >= date_add(now(), interval -1 month)
하루전
where reg_date >= date_add(now(), interval -1 day)
한시간전
where reg_date >= date_add(now(), interval -1 hour)
---
하루전
SELECT COLUMN1,2.... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 DAY ) AND NOW();
일주일전
SELECT COLUMN1,2.... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 WEEK ) AND NOW();
한달전
SELECT COLUMN1,2.... FROM TABLE WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(),INTERVAL -1 MONTH ) AND NOW();
300x250