MySQL Function Reference

TIMESTAMPDIFF

Returns the difference between two DATE or DATETIME in a specific unit of measurement

MySQL 8.1

TIMESTAMPDIFF(unit, datetime1, datetime2)

unit

The unit of measurement in which to return the difference between the values.

datetime1

The value to be subtracted from datetime2

datetime2

The value from which datetime1 will be subtracted

Examples

MySQL 8.1

SELECT TIMESTAMPDIFF(YEAR, '2012-06-12', '2022-12-05');

MySQL 8.1

SELECT TIMESTAMPDIFF(DAY, '2022-06-12', '2022-12-05');