MySQL Functions, JSON, and Date Cheatsheet/Compute the difference between two timestamps

Calculate age or duration.

Section: date and time functions

Compute the difference between two timestamps

sql
sql
SELECT TIMESTAMPDIFF(MINUTE, created_at, NOW()) AS age_minutes FROM sessions;
Explanation

Useful for SLAs, queue age, and freshness calculations.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing date and time functions
Get the current date and time
Return current timestamp values.
OpenIn sheetsqlsame section
Add an interval to a date
Calculate a future date or time.
OpenIn sheetsqlsame section
Subtract an interval
Calculate a relative date in the past.
OpenIn sheetsqlsame section
Format dates for display
Render a datetime using format specifiers.
OpenIn sheetsqlsame section
Extract a value from JSON
Read a path inside a JSON document.
Update a JSON path
Write or replace a value inside a JSON document.