Using MySQL’s TIMESTAMP vs storing timestamps directly
I’m in a dilemma about saving date and time values in MySQL’s TIMESTAMP format vs in a custom UNSIGNED INT format. The main considerations here are speed of retrieval, appropriate range calculations in PHP and occasional formatting into human readable values.