How to calculate the difference between two times using SQL statement?

In SQL, you can use the built-in function TIMESTAMPDIFF to calculate the difference between two times. This function takes three parameters: the time unit, the start time, and the end time. Here is an example:

SELECT TIMESTAMPDIFF(SECOND, start_time, end_time) AS time_difference
FROM your_table;

In the example above, we calculated the difference in seconds between start_time and end_time and named the result as time_difference. You can choose other time units such as MINUTE, HOUR, or DAY as needed.