What is the difference between timestamp in Unix and MySQL?

In Unix as well as in MySQL, timestamp is stored as a 32-bit integer.

A timestamp is the number of seconds from the Unix Epoch on January 1st, 1970 at UTC.

In MySQL we can represent the timestamp in a readable format.

Timestamp format in MySQL is YYYY-MM-DD HH:MM:SS

Read the full book at www.amazon.com
Posted in MySQL, MySQL Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *

*