MySQL data type question: timestamp versus integer to hold time
I am designing and programming a PHP/MySQL application that implements an interactive link directory application where users can register and submit links.
My question is simple. I am using a field to store the time of registration, time a link is submitted etc. in my tables in the MySQL database.
Which type is better for this field: integer or timestamp?