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()))
聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
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
