mysql timediff

Solutions on MaxInterview for mysql timediff by the best coders in the world

showing results for - "mysql timediff"
Leah
25 Sep 2020
1SET @date1 = '2010-10-11 00:00:00', @date2 = '2010-10-10 00:00:00';
2SELECT 
3  TIMEDIFF(@date1, @date2) AS 'TIMEDIFF',
4  TIMESTAMPDIFF(hour, @date1, @date2) AS 'TIMESTAMPDIFF';
5