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>
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>
SELECT ADDDATE('2014-1-16 12:13:16',INTERVAL DATEDIFF(NOW(),'2014-1-16 12:13:16') DAY);
SELECT TIMESTAMP(CURDATE(), TIME(@ddatetime))