[MySQL] Datetime 기준으로 조회하기

1. 특정 날짜 데이터 조회하기

SELECT * FROM [TABLE] WHERE DATE([DATE_COLUMN]) = '2021-11-01';

SELECT * FROM [TABLE] WHERE [DATE_COLUMN] >= '2021-11-01' AND [DATE_COLUMN] < '2021-11-02';

 

2. 특정 기간 데이터 조회하기

SELECT * FROM [TABLE] WHERE [DATE_COLUMN] BETWEEM '2021-11-01' AND '2021-11-31';

SELECT * FROM [TABLE] WHERE [DATE_COLUMN] >= '2021-11-01' AND [DATE_COLUMN] <= '2021-11-31';

 

---

참고자료

cs982607's blog