Answers for "datetime diff in mysql"

PHP
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 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

Browse Popular Code Answers by Language