updating timestamp with 1 day

[look_at_me]

Hi !
I've got a timestamp in a database, created with
tid timestamp(14)
Now, i need to update 'tid' with 1 day. You know, like the timestamp was created tomorrow.
mysql_query("UPDATE mytable SET tid=tid+1day");
Is there a way to do this ?
Thanks in advance 🙂

[LordShryku]

http://www.mysql.com/doc/en/Date_and_time_functions.html

Look at DATE_ADD or ADDDATE

[look_at_me]

Thanks ! Got it working like a charm 🙂