mysql 时间 秒数,mysql计算每天两个日期/时间之间的秒数

I have this table but I am helpless how to calculate seconds for each separate day from this table:

id from to

---------------------------------------------------

1 2013-01-31 23:50:00 2013-02-02 09:00:00

2 2013-02-05 11:21:12 2013-02-08 01:01:01

3 2013-02-08 17:33:44 2013-02-08 18:22:55

4 2013-02-12 01:40:12 2013-02-12 02:00:59

5 2013-02-28 01:40:12 2013-03-02 02:00:59

Now I need to gain number of seconds for each day in february between from and to.

so for 1st Feb - x seconds, 2nd Feb - y seconds, 3rd Feb - 0 seconds, etc. Any idea how should I do it? Many thanks.

解决方案SELECT TIMESTAMPDIFF(SECOND,from,to);

Example:

SELECT TIMESTAMPDIFF(SECOND,'2016-01-01 00:00:00','2016-01-11 00:00:00'); -- 864000

SELECT TIMESTAMPDIFF(MINUTE,'2016-01-01 00:00:00','2016-01-11 00:00:00'); -- 14400

SELECT TIMESTAMPDIFF(HOUR,'2016-01-01 00:00:00','2016-01-11 00:00:00'); -- 240

SELECT TIMESTAMPDIFF(DAY,'2016-01-01 00:00:00','2016-01-11 00:00:00'); -- 10