Mysql計算時間間隔函數(shù)_MySQL
來源：懂視網(wǎng)
責(zé)編：小采
時間：2020-11-09 19:30:04
Mysql計算時間間隔函數(shù)_MySQL
Mysql計算時間間隔函數(shù)_MySQL:#計算兩個時間的間隔#計算間隔天數(shù)select TIMESTAMPDIFF(day,'2014-06-01',date(now()))#計算間隔月數(shù)select TIMESTAMPDIFF(month,'2014-01-01',date(now()))#計算間隔年數(shù)select TIMESTAMPDIFF(year,'2010-01-0
導(dǎo)讀Mysql計算時間間隔函數(shù)_MySQL:#計算兩個時間的間隔#計算間隔天數(shù)select TIMESTAMPDIFF(day,'2014-06-01',date(now()))#計算間隔月數(shù)select TIMESTAMPDIFF(month,'2014-01-01',date(now()))#計算間隔年數(shù)select TIMESTAMPDIFF(year,'2010-01-0
#計算兩個時間的間隔
#計算間隔天數(shù)
select TIMESTAMPDIFF(day,'2014-06-01',date(now()))
#計算間隔月數(shù)
select TIMESTAMPDIFF(month,'2014-01-01',date(now()))
#計算間隔年數(shù)
select TIMESTAMPDIFF(year,'2010-01-01',date(now()))
聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
Mysql計算時間間隔函數(shù)_MySQL
Mysql計算時間間隔函數(shù)_MySQL:#計算兩個時間的間隔#計算間隔天數(shù)select TIMESTAMPDIFF(day,'2014-06-01',date(now()))#計算間隔月數(shù)select TIMESTAMPDIFF(month,'2014-01-01',date(now()))#計算間隔年數(shù)select TIMESTAMPDIFF(year,'2010-01-0
