Answers for "mysql time diff"

SQL
7

mysql date diff

SELECT DATEDIFF(expr1,expr2) as difference_in_days;


select DATEDIFF('2020-05-15', '2020-05-10'); //returns 5
select DATEDIFF('2020-05-13', '2020-05-16'); //returns -3
select DATEDIFF('2020-06-30', '2020-05-30'); //returns 30
Posted by: Guest on May-22-2020
2

mysql time ago difference

#Need item created 12 hours ago or newer. Discards older than 12 hours
	 created_at >= (NOW() - INTERVAL 12 HOUR)
Posted by: Guest on October-27-2020
0

mysql date diff in seconds

SELECT TIME_TO_SEC(TIMEDIFF('2021-05-22 12:00:00', '2021-05-22 12:00:37')) as diff_in_seconds;
Posted by: Guest on September-30-2021
0

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';
Posted by: Guest on October-23-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language