데이터베이스/SQL

[SQL] MySQL 하루, 일주일, 한달 데이터 조회하기

Reference M1 2020. 6. 24. 00:02

 

-- 하루
SELECT COLUMN1
     , COLUMN2
     , COLUMN3
     , ....
  FROM TABLE
 WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(), INTERVAL -1 DAY) AND NOW();

 

-- 일주일
SELECT COLUMN1
     , COLUMN2
     , COLUMN3
     , ....
  FROM TABLE
 WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(), INTERVAL -1 WEEK) AND NOW();

 

-- 한달
SELECT COLUMN1
     , COLUMN2
     , COLUMN3
     , ....
  FROM TABLE
 WHERE DATE_COLUMN BETWEEN DATE_ADD(NOW(), INTERVAL -1 MONTH) AND NOW();