wordpress初级教程,海淀区seo全面优化,东莞太子酒店,动态交互图表制作MySQL自带的日期函数TIMESTAMPDIFF计算两个日期相差的秒数、分钟数、小时数、天数、周数、季度数、月数、年数#xff0c;当前日期增加或者减少一天、一周等等。SELECT TIMESTAMPDIFF(类型,开始时间,结束时间)相差的秒数#xff1a;SELECT TIMESTAMPDIFF(SECOND,1993-03-23 0…MySQL自带的日期函数TIMESTAMPDIFF计算两个日期相差的秒数、分钟数、小时数、天数、周数、季度数、月数、年数当前日期增加或者减少一天、一周等等。SELECT TIMESTAMPDIFF(类型,开始时间,结束时间)相差的秒数SELECT TIMESTAMPDIFF(SECOND,1993-03-23 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))相差的分钟数SELECT TIMESTAMPDIFF(MINUTE,1993-03-23 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))相差的小时数SELECT TIMESTAMPDIFF(HOUR,1993-03-23 00:00:00 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))相差的天数SELECT TIMESTAMPDIFF(DAY,1993-03-23 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))相差的周数SELECT TIMESTAMPDIFF(WEEK,1993-03-23 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))相差的季度数SELECT TIMESTAMPDIFF(QUARTER,1993-03-23 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))相差的月数SELECT TIMESTAMPDIFF(MONTH,1993-03-23 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))相差的年数SELECT TIMESTAMPDIFF(YEAR,1993-03-23 00:00:00,DATE_FORMAT(NOW(), %Y-%m-%d %H:%i:%S))获取当前日期SELECT NOW()SELECT CURDATE()当前日期增加一天SELECT DATE_SUB(CURDATE(),INTERVAL -1 DAY)当前日期减少一天SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY)当前日期增加一周SELECT DATE_SUB(CURDATE(),INTERVAL -1 WEEK)SELECT DATE_SUB(NOW(),INTERVAL -1 MONTH)当前日期增加一月SELECT DATE_SUB(CURDATE(),INTERVAL -1 MONTH)FRAC_SECOND 毫秒SECOND 秒MINUTE 分钟HOUR 小时DAY 天WEEK 星期MONTH 月QUARTER 季度YEAR 年总结以上所述是小编给大家简介的MySQL计算两个日期相差的天数、月数、年数,希望对大家有所帮助如果大家有任何疑问请给我留言小编会及时回复大家的。在此也非常感谢大家对乐购源码网址的支持如果你觉得本文对你有帮助欢迎转载烦请注明出处谢谢
