How to calculate the time difference in MySQL?

To calculate the time difference in MySQL use function TIMEDIFF that returns the difference between the hours, along with the function CURTIME() that returns the current time.

Example:

SELECT TIMEDIFF(CURTIME(), hora) as dif 
               FROM conversas WHERE de=7 ORDER BY id DESC LIMIT 1;

References:

• MySQL

• TIMEDIFF(expr1,expr2)

• CURTIME()

Dude I was with the same doubt and it helped me

link

ex .. SELECT TIMESTAMPDIFF (SECOND, open_add, cas_data_data), user_name, cas_status, cas_data_de_opertura, cas_data_de_claramento FROM case INNER JOIN user ON case.usu_id = user.usu_id WHERE cas_status = 'Closed' AND cas_id = 75