TIMEDIFF问题。貌似时间相差太久会溢出? TIMEDIFF问题。貌似时间相差太久会溢出?我使用了TIME_DIFF,两个时间相差大概2~3个月左右,结果就返回错误了。如果我想知道两个日期相差的秒数,我该如果去做呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select DATEDIFF('2011-5-31 ' ,'2011-1-1' )*24*60 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> 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) SELECT TIMESTAMPDIFF(SECOND, '1991-01-01 9:59:59', '2011-12-31 10:00:00'); 列名是变量名怎么办 请各位大神指点如何执行'use database_name'类型的字符串SQL mysql 远程连接的问题 清华网络中心笔试题 请教了!我是新手钱不多,但是是诚心诚意的请教! 郁闷!! 初学sql,如何模糊替换 如何提高mysql查询中使用not in时的查询速度? 求一sql语句,设置表a.col字段的值,等于 表b.col2 的值,但是是随机的,没有 类似a.id=b.id mysql数据库多表查询 使用sqlyong操作mysql插入中文提示1366错误 用C++写了一个用mysql作数据的服务器,内存占用越来越大? MYSQL下如何批量写入,批量更新数据?
+-----------------------------------------------------------+
| UNIX_TIMESTAMP('2011-10-10')-UNIX_TIMESTAMP('2011-10-09') |
+-----------------------------------------------------------+
| 86400 |
+-----------------------------------------------------------+
1 row in setmysql>
+--------------------------------------------------------------------------------------+
| time_to_sec( timediff( convert('2011-5-23',datetime),convert('2011-5-22',datetime))) |
+--------------------------------------------------------------------------------------+
| 86400 |
+--------------------------------------------------------------------------------------+
1 row in set (0.00 sec)