Premium
Log in
TIMESTAMPDIFF(unit, datetime1, datetime2)
Unit type | Description |
---|---|
MICROSECOND | Microseconds |
SECOND | Seconds |
MINUTE | Minutes |
HOUR | Hours |
DAY | Days |
WEEK | Weeks |
MONTH | Months |
QUARTER | Quarter |
YEAR | Years |
SELECT TIMESTAMPDIFF(YEAR,'2012-06-12','2022-12-05');
SELECT TIMESTAMPDIFF(DAY,'2022-06-12','2022-12-05');