Mysql timediff

SET @date1 = '2010-10-11 00:00:00', @date2 = '2010-10-10 00:00:00';
SELECT 
  TIMEDIFF(@date1, @date2) AS 'TIMEDIFF',
  TIMESTAMPDIFF(hour, @date1, @date2) AS 'TIMESTAMPDIFF';

Source: database.guide

Similar codes

16 votes375 views1 answer
Mysql reset auto increment value
SQL
11 votes353 views5 answers
How to install sqlite3 python
SQL
0 vote454 views1 answer
How to subquey to do not load in live database in
SQL
0 vote355 views1 answer
Drop procedure sql
SQL
2 votes352 views6 answers
In operator in sql
SQL
0 vote353 views1 answer
Set a value by excuting stored procedure
SQL
32 votes370 views6 answers
How to change column name in sql
SQL
0 vote397 views1 answer
Sql pivot without aggregate
SQL
8 votes363 views1 answer
Oracle search code in packages
SQL
0 vote348 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL