Mysql计算时间间隔函数_MySQL
来源：懂视网
责编：小采
时间：2020-11-09 19:30:04
Mysql计算时间间隔函数_MySQL
Mysql计算时间间隔函数_MySQL:#计算两个时间的间隔#计算间隔天数select TIMESTAMPDIFF(day,'2014-06-01',date(now()))#计算间隔月数select TIMESTAMPDIFF(month,'2014-01-01',date(now()))#计算间隔年数select TIMESTAMPDIFF(year,'2010-01-0
导读Mysql计算时间间隔函数_MySQL:#计算两个时间的间隔#计算间隔天数select TIMESTAMPDIFF(day,'2014-06-01',date(now()))#计算间隔月数select TIMESTAMPDIFF(month,'2014-01-01',date(now()))#计算间隔年数select TIMESTAMPDIFF(year,'2010-01-0
#计算两个时间的间隔
#计算间隔天数
select TIMESTAMPDIFF(day,'2014-06-01',date(now()))
#计算间隔月数
select TIMESTAMPDIFF(month,'2014-01-01',date(now()))
#计算间隔年数
select TIMESTAMPDIFF(year,'2010-01-01',date(now()))
Mysql计算时间间隔函数_MySQL
Mysql计算时间间隔函数_MySQL:#计算两个时间的间隔#计算间隔天数select TIMESTAMPDIFF(day,'2014-06-01',date(now()))#计算间隔月数select TIMESTAMPDIFF(month,'2014-01-01',date(now()))#计算间隔年数select TIMESTAMPDIFF(year,'2010-01-0
