How to calculate the time difference in MySQL?

In MySQL, you can use the TIMESTAMPDIFF(unit, datetime1, datetime2) function to calculate the time difference between two datetime values, where the unit parameter specifies the desired time unit, and datetime1 and datetime2 are the two datetime values for which the difference is being calculated.

Here is an example of calculating the time difference using the TIMESTAMPDIFF() function:

SELECT TIMESTAMPDIFF(SECOND, '2021-01-01 10:00:00', '2021-01-01 11:30:00') AS time_diff;

The above example will calculate the time difference between two dates and times, and return the result in seconds.