hrs en tre hraini y hrafin

[huesos52]

Código mysql:

mysql> select *from ts;
+---------------------+---------------------+
| fecha               | fecha2              |
+---------------------+---------------------+
| 2009-11-17 13:22:40 | 2009-11-17 14:33:30 |
+---------------------+---------------------+
1 row in set (0.00 sec)
 
mysql> select sec_to_time(time_to_sec(time(fecha2))-time_to_sec(time(fecha))) tiempo_transcurrido from ts;
+---------------------+
| tiempo_transcurrido |
+---------------------+
| 01:10:50            |
+---------------------+
1 row in set (0.02 sec)
 
mysql>
 

Así?