What is the difference between `DATETIME` and `TIMESTAMP` in MySQL?

Question

Advanced SQL Developer — Medium

What is the difference between `DATETIME` and `TIMESTAMP` in MySQL?

Accepted Answer

The key difference between DATETIME and TIMESTAMP in MySQL is that TIMESTAMP stores values in UTC and converts to the session's timezone on retrieval, while DATETIME stores the literal value without timezone awareness. Additionally, TIMESTAMP has a limited range of 1970–2038, whereas DATETIME supports a wider range of 1000–9999.