TIMESTAMPdata type is used for values that contain both date and time parts.
TIMESTAMPhas a range of
'1970-01-01 00:00:01'UTC to
If you are using MySQL timestamps beware. In about 18 years from the time if this post you will have issues.
The MySQL timestamp field does not allow date ranges greater than 2038-01-19. This means that when you select a timestamp, the result will be zero. To illustrate this problem, run the following query on your MySQL server.
The result of this query is
For more information on the fun world of MySQL timestamps I recommend the following Stackoverflow post: