Difference between two dates in MySQL?

Question

How to calculate the difference between two dates, in the format `YYYY-MM-DD hh: mm: ss` and to get the result in seconds or milliseconds?

Answer 1

TIMESTAMPDIFF(datepart, datetime1, datetime2)

datepart = SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR