如何将当前时间戳与天数相加

Question

I have a column in my database which contains the current_TimeStamp, but I want to sum this time stamp with some number of days in php and insert the result into another column for example if the current time stamp is (2016-02-06 21:01:27) so I want to sum it with 3 which means 3 days, So I need your help

Answer 1

You can easy. see the SELECT. If you want to UPDATE a ROW you can direct calculate it

SELECT '2016-02-06 21:01:27' + INTERVAL 3 DAY;


UPDATE mytable SET newcolumn = mytimestamp + INTERVAL 3 DAY
 WHERE ....;