Check http://www.mysql.com/doc/en/Column_types.html for column types...
INT is good choice for storing seconds passed since 1970...
To add one year to TIMESTAMP-type, use ADDDATE or DATE_ADD (they are same) functions...(check http://www.mysql.com/doc/en/Date_and_time_functions.html for more...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.