Mysql timestamp query
- by Hulk
In mysql a result of a query is
say select timestamp from newbie;
| 2010-03-12 14:50:46 |
| 2010-03-12 14:50:46 |
| 2010-03-12 14:50:51 |
| 2010-03-12 14:50:52 |
| 2010-03-12 14:50:54 |
| 2010-03-12 14:51:04 |
| 2010-03-12 14:51:07 |
| 2010-03-12 14:51:08 |
Is there a way to subquery the above and sum up the i.e, the final result should be the delta of each row in hh:mm:ss format