Calculate the difference between hours in SQL

Navigation
0

How do I get a difference between two hours?

For example, between 07:30 and 09:00 , so you can tell me the difference in minutes, seconds and hours.

    
asked by Facundo Lupacchino 05.11.2017 в 08:43
source

1 answer

3

With the TIMEDIFF

function

SELECT TIMEDIFF("07:30:00", "09:00:00");

Here is the reference manual .

    
answered by 05.11.2017 / 09:36
source
input type="date" is not recognized in internet explorer 11 Execute AND statement dependent on a value of a variable