接刚才的timestamp类型的加法运算的问题 谢谢ACHMAIN_CHM对我刚才问题http://topic.csdn.net/u/20090611/12/e5a58556-2995-4fd6-bbb4-076569516dad.html的解答,日期是加了,但是加之前的日期是10位的int型字段,加完后怎么能保持仍然是10位int型的呢如 1241136000 加完30天后是 1342236000 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select FROM_UNIXTIME(1241136000) as a1, DATE_ADD(FROM_UNIXTIME(1241136000),INTERVAL 30 day) as a2,UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(1241136000),INTERVAL 30 day)) a3应该是 1243728000? mysql> select FROM_UNIXTIME(1127883316) as f1, -> DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 2 day) as f2, -> UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 2 day)) as f3;+---------------------+---------------------+------------+| f1 | f2 | f3 |+---------------------+---------------------+------------+| 2005-09-28 12:55:16 | 2005-09-30 12:55:16 | 1128056116 |+---------------------+---------------------+------------+1 row in set (0.00 sec)mysql> 但你如果是加 30 天你还不如直接select 1127883316 + 30*24*60*60;mysql> select FROM_UNIXTIME(1127883316) as f1, -> DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 30 day) as f2, -> UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 30 day)) as f3;+---------------------+---------------------+------------+| f1 | f2 | f3 |+---------------------+---------------------+------------+| 2005-09-28 12:55:16 | 2005-10-28 12:55:16 | 1130475316 |+---------------------+---------------------+------------+1 row in set (0.00 sec)mysql> select 1127883316 + 30*24*60*60;+--------------------------+| 1127883316 + 30*24*60*60 |+--------------------------+| 1130475316 |+--------------------------+1 row in set (0.00 sec)mysql> 基础问题,MAC上安装了mysql,结果终端自动连接mysql mysql如何优化联合查询速度 mysql 语句 MATCH() AGAINST 的问题 大家帮忙看下,这样的查询该怎么写? group by 在安装mysql-4.0.26 时,出现了问题,哪位大侠能告诉我是怎么回事呀??(我的操作系统是WIN 2000 server) postgres sql的问题 根据条件查询不同表 复合查询 mysql set @auto_increment_increment=10 不起作用 select in 转 select exists 着急着急着急!!在线等
DATE_ADD(FROM_UNIXTIME(1241136000),INTERVAL 30 day) as a2,
UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(1241136000),INTERVAL 30 day)) a3应该是 1243728000?
-> DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 2 day) as f2,
-> UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 2 day)) as f3;
+---------------------+---------------------+------------+
| f1 | f2 | f3 |
+---------------------+---------------------+------------+
| 2005-09-28 12:55:16 | 2005-09-30 12:55:16 | 1128056116 |
+---------------------+---------------------+------------+
1 row in set (0.00 sec)mysql>
select 1127883316 + 30*24*60*60;mysql> select FROM_UNIXTIME(1127883316) as f1,
-> DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 30 day) as f2,
-> UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(1127883316),INTERVAL 30 day)) as f3;
+---------------------+---------------------+------------+
| f1 | f2 | f3 |
+---------------------+---------------------+------------+
| 2005-09-28 12:55:16 | 2005-10-28 12:55:16 | 1130475316 |
+---------------------+---------------------+------------+
1 row in set (0.00 sec)mysql> select 1127883316 + 30*24*60*60;
+--------------------------+
| 1127883316 + 30*24*60*60 |
+--------------------------+
| 1130475316 |
+--------------------------+
1 row in set (0.00 sec)mysql>