mysql中关于日期函数以及日期计算的sql总汇
SELECT NOW();
SELECT CURDATE();
SELECT LAST_DAY(NOW())
SELECT LAST_DAY('2000-02-01')
SELECT YEAR(NOW());
SELECT MONTH(NOW());
SELECT DAY(NOW());
SELECT YEAR('日期') YEAR,MONTH('日期') MONTH,DAY('日期') DAY FROM 表名 WHERE 条件
SELECT *FROM 表名 WHERE DAY('日期')=13
SELECT * FROM 表名 WHERE MONTH('日期')=MONTH(NOW())
SELECT TIMESTAMPDIFF(DAY,'2019-10-23',NOW())
SELECT TIMESTAMPDIFF(MONTH,'2019-10-23',NOW())
SELECT TIMESTAMPDIFF(YEAR,'2016-11-23',NOW())
SELECT * FROM 表名 WHERE TIMESTAMPDIFF(MONTH,'日期',NOW())>3
SELECT * FROM 表名 WHERE YEAR(NOW())-YEAR('日期')>=3