mysql time diff code example
Example 1: mysql date diff
SELECT DATEDIFF(expr1,expr2) as difference_in_days;
select DATEDIFF('2020-05-15', '2020-05-10');
select DATEDIFF('2020-05-13', '2020-05-16');
select DATEDIFF('2020-06-30', '2020-05-30');
Example 2: mysql time ago difference
created_at >= (NOW() - INTERVAL 12 HOUR)
Example 3: 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';