mysql> select hour(TIMEDIFF('2010-02-08 10:50:10','2010-02-06 9:00:00'));
+------------------------------------------------------------+
| hour(TIMEDIFF('2010-02-08 10:50:10','2010-02-06 9:00:00')) |
+------------------------------------------------------------+
| 49 |
+------------------------------------------------------------+