날짜와 관련된 함수(DATE 타입)
- YEAR, MONTH, DAYOFMONTH(년, 월, 일)
SELECT * FROM main_database.member WHERE YEAR(birthday) = 1997;
SELECT * FROM main_database.member WHERE MONTH(birthday) IN (6,7,8);
SELECT * FROM main_database.member WHERE DAYOFMONTH(birthday) BETWEEN 15 AND 31;
- DATEDIFF(날짜 a, 날짜 b), 날짜간의 차이 구하기
SELECT sign_up_day, DATEDIFF(sign_up_day, '2021-01-01') FROM main_database.member;
SELECT sign_up_day, CURDATRE(), DATEDIFF(sign_up_day, CURDATE()) FROM main_database.member;
- DATE_ADD(), DATE_SUB(), 날짜 더하기 빼기
SELECT email, sign_up_day, DATE_ADD(sign_up_day, INTERVAL 300 DAY) FROM main_database.member;
SELECT email, sign_up_day, DATE_SUB(sign_up_day, INTERVAL 200 DAY) FROM main_database.member;