답변 2개
채택된 답변
+20 포인트
date 타입으로 주면 될것 같습니다.
https://dev.mysql.com/doc/refman/5.5/en/date-and-time-literals.html
Copy
CREATE TABLE `dates` ( `f1` date DEFAULT NULL);INSERT INTO dates (f1) VALUES (CURRENT_DATE());INSERT INTO dates (f1) VALUES (DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY));INSERT INTO dates (f1) VALUES (DATE_SUB(CURRENT_DATE(), INTERVAL 2 DAY));INSERT INTO dates (f1) VALUES (DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY));SELECT * FROM dates WHERE f1 < CURRENT_DATE();SELECT * FROM dates WHERE f1 < DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY);SELECT * FROM dates WHERE f1 < DATE_SUB(CURRENT_DATE(), INTERVAL 2 DAY);SELECT * FROM dates WHERE f1 < DATE_SUB(CURRENT_DATE(), INTERVAL 3 DAY);답변을 작성하려면 로그인이 필요합니다.