MySQL 获取时间差、格式化

获取时间差

SELECT TIMESTAMPDIFF(YEAR,'2003-02-01','2005-05-01');
SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
SELECT TIMESTAMPDIFF(DAY,'2003-02-01','2003-05-01');
SELECT TIMESTAMPDIFF(HOUR,'2003-02-01','2003-05-01');
SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01');
SELECT TIMESTAMPDIFF(SECOND,'2003-02-01','2003-05-01');

时间格式化

参考: https://www.cnblogs.com/duhuo/p/5650876.html

SELECT DATE_FORMAT('2003-02-01 13:05:30','%Y-%m-%d %H:%i:%S')
SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:%S')
SELECT DATE_FORMAT(CURDATE(),'%Y-%m-%d %H:%i:%S')