any special advantage of datetime except date range that a timestamp can't???

timestamp is the date and time the record was last updated
datetime is a datatype that date and/or time data is stored in

For TIMESTAMP column you can have DEFAULT CURRENT_TIMESTAMP that cannot be specified for DATETIME.

Not a big issue, just another difference between data types. By the way, only one TIMESTAMP column can have this default.

Dmitry

--
http://www.sqlines.com/online - Free SQL conversion between major databases

You got the major difference. Storage size is different as a result:

TIMESTAMP uses 4 bytes of storage and can store date from 1970 to 2037

DATETIME uses 8 bytes of storage and can store any date/time from 0000-00-00 00:00:00 to 9999-12-31 23:59:59.

If you are building a time machine, please be sure to use DATETIME.

doesn't has to be, but this is a very common usage

Although DATETIME can store year 0000, the next allowed year is 1000

Dmitry

--
http://www.sqlines.com/online - Free SQL conversion between major databases

Oh, very interesting. Thanks for the info