mysql修改时间，把年月日改为当天，时分秒不变怎么修改

[范佩西_11]

比如我要把2014-1-16 12:13:16秒改成当天也就是：2014-2-7 12:13:16
怎么改。
把年月日改为当天，时分秒不变怎么修改

[ACMAIN_CHM]

mysql> set @d='2014-1-16 12:13:16';
Query OK, 0 rows affected (0.00 sec)

mysql> select @d,ADDTIME (curdate()+interval 0 hour,time(@d)) as n;
+--------------------+---------------------+
| @d                 | n                   |
+--------------------+---------------------+
| 2014-1-16 12:13:16 | 2014-02-07 12:13:16 |
+--------------------+---------------------+
1 row in set (0.00 sec)

mysql>

[rucypli]

引用 1 楼 ACMAIN_CHM 的回复:

mysql> set @d='2014-1-16 12:13:16';
Query OK, 0 rows affected (0.00 sec)

mysql> select @d,ADDTIME (curdate()+interval 0 hour,time(@d)) as n;
+--------------------+---------------------+
| @d                 | n                   |
+--------------------+---------------------+
| 2014-1-16 12:13:16 | 2014-02-07 12:13:16 |
+--------------------+---------------------+
1 row in set (0.00 sec)

mysql>

[ayzen1988]

SELECT ADDDATE('2014-1-16 12:13:16',INTERVAL DATEDIFF(NOW(),'2014-1-16 12:13:16') DAY);

[tian790317]

一定要学习下了

[-江沐风-]

引用 1 楼 ACMAIN_CHM 的回复:

mysql> set @d='2014-1-16 12:13:16';
Query OK, 0 rows affected (0.00 sec)

mysql> select @d,ADDTIME (curdate()+interval 0 hour,time(@d)) as n;
+--------------------+---------------------+
| @d                 | n                   |
+--------------------+---------------------+
| 2014-1-16 12:13:16 | 2014-02-07 12:13:16 |
+--------------------+---------------------+
1 row in set (0.00 sec)

mysql>

引用 2 楼 rucypli 的回复:

[quote=引用 1 楼 ACMAIN_CHM 的回复:]

mysql> set @d='2014-1-16 12:13:16';
Query OK, 0 rows affected (0.00 sec)

mysql> select @d,ADDTIME (curdate()+interval 0 hour,time(@d)) as n;
+--------------------+---------------------+
| @d                 | n                   |
+--------------------+---------------------+
| 2014-1-16 12:13:16 | 2014-02-07 12:13:16 |
+--------------------+---------------------+
1 row in set (0.00 sec)

mysql>

[/quote] 大版主和小版主果然牛！

[ermuzi]

SET @ddatetime = '2014-2-7 12:13:16';
SELECT TIMESTAMP(CURDATE(), TIME(@ddatetime))

[范佩西_11]

我的数据库是网站空间的数据库用phpmyadmin登的，不可以使用ADDTIME函数啊