DATEDIFF o parecido, sacar minutos, segundos

[huesos52]

Con timestampdiff puedes hacerlo.

Código mysql:

mysql> SELECT DATEDIFF('1997-12-30 23:00:00','1997-12-30 22:20:00');
+-------------------------------------------------------+
| DATEDIFF('1997-12-30 23:00:00','1997-12-30 22:20:00') |
+-------------------------------------------------------+
|                                                     0 |
+-------------------------------------------------------+
1 row in set (0.01 sec)
 
mysql> SELECT timestampDIFF(second,'1997-12-30 23:00:00','1997-12-30 22:20:00') diffsecond
+------------+
| diffsecond |
+------------+
|      -2400 |
+------------+
1 row in set (0.00 sec)
 
mysql> SELECT timestampDIFF(minute,'1997-12-30 23:00:00','1997-12-30 22:20:00') diffminute
+------------+
| diffminute |
+------------+
|        -40 |
+------------+
1 row in set (0.02 sec)
 
 
mysql>