Understand the Timezone Differences between DATETIME and TIMESTAMP Fields in MySQL

Learn to store and display time with timezone info correctly in MySQL

Image by geralt on Pixabay

There are some subtle but important differences between the DATETIME and TIMESTAMP fields in MySQL. The most prominent difference is that a TIMESTAMP field can only store dates from 1970 to 2038, while a…