SELECT trouble with DIFFTIME

Question

I want to know the time difference between two dates. for example:

    SELECT TIMEDIFF('2012-12-19 22:00:00','2012-12-10 19:00:00');
+-------------------------------------------------------+
| TIMEDIFF('2012-12-19 22:00:00','2012-12-10 19:00:00') |
+-------------------------------------------------------+
| 219:00:00                                             |
+-------------------------------------------------------+
1 row in set (0.00 sec)

Now i want to extract the hours.

mysql> SELECT HOUR(SELECT TIMEDIFF('2012-12-19 22:00:00','2012-12-10 19:00:00'));
ERROR 1064 (42000):

Why doesn't work?

score 2 · Accepted Answer · answered Dec 20 '12 at 03:54

2

Try:

SELECT HOUR(TIMEDIFF('2012-12-19 22:00:00','2012-12-10 19:00:00'));

answered Dec 20 '12 at 03:54

Raisen

4,385
2
25
40

score 0 · Answer 2 · edited Jan 20 '16 at 09:03

0

This could resolve your problem:

SELECT TIME_FORMAT(TIMEDIFF('2012-12-19 22:00:00','2012-12-10 19:00:00'),'%H');

edited Jan 20 '16 at 09:03

CoderPi

12,985
4
34
62

answered Jan 20 '16 at 08:47

Jorge Marroquin

1

SELECT trouble with DIFFTIME

2 Answers2