請問mysql的sql中如何計算兩個datetime的差，精確到小時，謝謝

TIMESTAMPDIFF(interval,datetime_expr1,datetime_expr2)

返回日期或日期時間表達式datetime_expr1?和datetime_expr2the?之間的整數差。

其結果的單位由interval?參數給出。該參數必須是以下值的其中壹個：

FRAC_SECOND?表示間隔是毫秒

SECOND?秒

MINUTE?分鐘

HOUR?小時

DAY?天

WEEK?星期

MONTH?月

QUARTER?季度

YEAR?年

SELECT?'年'?AS?`日期部分`,?TIMESTAMPDIFF(YEAR,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

UNION?ALL

SELECT?'季度'?AS?`日期部分`,?TIMESTAMPDIFF(QUARTER,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

UNION?ALL

SELECT?'月'?AS?`日期部分`,?TIMESTAMPDIFF(MONTH,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

UNION?ALL

SELECT?'日'?AS?`日期部分`,?TIMESTAMPDIFF(DAY,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

UNION?ALL

SELECT?'周'?AS?`日期部分`,TIMESTAMPDIFF(WEEK,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

UNION?ALL

SELECT?'時'?AS?`日期部分`,TIMESTAMPDIFF(HOUR,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

UNION?ALL

SELECT?'分'?AS?`日期部分`,TIMESTAMPDIFF(MINUTE,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

UNION?ALL

SELECT?'秒'?AS?`日期部分`,TIMESTAMPDIFF(SECOND,?'2012-12-21',?CURRENT_TIMESTAMP())?AS?`數值`

+----------+----------+

|?日期部分?|?數值?|

+----------+----------+

|?年|1?|

|?季度?|4?|

|?月|12?|

|?日|?388?|

|?周|55?|

|?時|?9328?|

|?分|559737?|

|?秒|?33584279?|

+----------+----------+

8?rows?in?set?(0.00?sec)

mysql>?select?CURRENT_TIMESTAMP();

+---------------------+

|?CURRENT_TIMESTAMP()?|

+---------------------+

|?2014-01-13?16:58:17?|

+---------------------+

1?row?in?set?(0.00?sec)

上一篇:求初音ミク的銀のフルーフ的羅馬音

下一篇:梅州那裏有疫情嗎