Answers for "duration from date to date in mysql"

mysql get date difference in hours

SELECT TIMESTAMPDIFF(HOUR, '2021-05-22 07:00:00', '2021-05-22 12:00:37') as time_diff_in_hours;

Posted by: Guest on September-30-2021

date between in mysql

SELECT * FROM `objects` 
WHERE  (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')

Posted by: Guest on May-06-2021

Code answers related to "duration from date to date in mysql"