mysql & mariadb 한달전, 하루전, 한시간전

한달전

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();