For storing the dates in a database, I would use 'datetime' columns, which can be set using the databases own now() function.
Using datetime column types will allow you to do datetime calculations within your 'where' query.
Also note the funky 'timestamp' column which will update the recorded datetime automatically whenever it's changed or read.

read more in the mysql.com documentation.