How does MySQL store timestamps internally?

Question

How does MySQL store timestamps internally? Is it an int, or a string or something else?

Answer 1

I believe it uses a UNIX timestamp, which is an integer representing the number of seconds since the UNIX epoch: Jan 01 1970

Answer 2

32bit integer

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

Answer 3

From the MySQL Documentation:

TIMESTAMP: A four-byte integer representing seconds UTC since the epoch ('1970-01-01 00:00:00' UTC)