计算两个时间戳差多少个小时？

Question

计算两个时间戳差多少个小时？

Answer 1

SELECT TIMEDIFF('2009-05-20 15:41:26','2009-05-20 11:36:13');

Answer 2

or
SELECT TIMESTAMPDIFF(hour,'2003-05-01 03:02:01','2003-05-01 03:05:01');
        

Answer 3

mysql> SELECT TIMESTAMPDIFF(HOUR,'2009-05-20 15:41:26','2009-05-20 11:36:13');
+-----------------------------------------------------------------+
| TIMESTAMPDIFF(HOUR,'2009-05-20 15:41:26','2009-05-20 11:36:13') |
+-----------------------------------------------------------------+
|                                                              -4 |
+-----------------------------------------------------------------+
1 row in set (0.00 sec)mysql>

Answer 4

时间戳
1179478500
1179565560这两个时间戳差多少个小时，，不转成yyyy-mm-dd

Answer 5

mysql> SELECT TIMESTAMPDIFF(HOUR,FROM_UNIXTIME(1179478500),FROM_UNIXTIME(1179565
560));
+-------------------------------------------------------------------------+
| TIMESTAMPDIFF(HOUR,FROM_UNIXTIME(1179478500),FROM_UNIXTIME(1179565560)) |
+-------------------------------------------------------------------------+
|                                                                      24 |
+-------------------------------------------------------------------------+
1 row in set (0.00 sec)mysql>

Answer 6

两个时间戳差多少个小时，有没有不转成datetime这种形式就能计算出来的办法。。