DB/MYSQL
[ MYSQL ] 날짜 증가 후 조회
HEON.D
2022. 5. 27. 03:03
(date_sub('$date', interval '12' month) 12달
(date_sub('$date', interval '1' day) 하루
Today
WHERE t_date=CURDATE();
Tomarrow
WHERE t_date=CURDATE() + INTERVAL 1 DAY;
Yesterday
WHERE t_date=CURDATE() - INTERVAL 1 DAY;