TIMEDIFF问题。貌似时间相差太久会溢出？

TIMEDIFF问题。貌似时间相差太久会溢出？我使用了TIME_DIFF，两个时间相差大概2~3个月左右，结果就返回错误了。
如果我想知道两个日期相差的秒数，我该如果去做呢？

解决方案 »

  1.   

    select DATEDIFF('2011-5-31 ' ,'2011-1-1' )*24*60
      

  2.   

    mysql> SELECT UNIX_TIMESTAMP('2011-10-10')-UNIX_TIMESTAMP('2011-10-09'); 
    +-----------------------------------------------------------+
    | UNIX_TIMESTAMP('2011-10-10')-UNIX_TIMESTAMP('2011-10-09') |
    +-----------------------------------------------------------+
    |                                                     86400 |
    +-----------------------------------------------------------+
    1 row in setmysql> 
      

  3.   

    mysql> select time_to_sec( timediff( convert('2011-5-23',datetime),convert('2011-5-22',datetime)));
    +--------------------------------------------------------------------------------------+
    | time_to_sec( timediff( convert('2011-5-23',datetime),convert('2011-5-22',datetime))) |
    +--------------------------------------------------------------------------------------+
    |                                                                                86400 |
    +--------------------------------------------------------------------------------------+
    1 row in set (0.00 sec)
      

  4.   

    SELECT TIMESTAMPDIFF(SECOND, '1991-01-01 9:59:59', '2011-12-31 10:00:00');