TIMESTAMP contain the date and time parts, so can you tell me what's the difference between them?
There are several differences between
DATETIMEsupported range is from '
1000-01-01 00:00:00' to '
TIMESTAMPsupported range is from '
1970-01-01 00:00:01' UTC to '
2038-01-19 03:14:07' UTC.
TIMESTAMPis generally used to track changes to records, and is often updated every time the record is changed,
DATETIMEis generally used to store a specific value.