Date Difference in MySQL in Minutes

Question

I need to find the time difference in Hours for the following Dates in MySQL - Can i use Datediff functions?

2014-01-01 07:27:21 and 2014-02-01 11:29:00

I tried using DATEDIFF(MINUTE,'2014-01-01 07:27:21','2014-01-01 11:29:00') but apparently MySQL is giving an error.

I tried Using DATEDIFF(MINUTE,'2014-01-01 07:27:21','2014-01-01 11:29:00') but apparently MySQL is giving an error. — Alankar, Mar 28 '14 at 23:45
Top Google result for the title: http://answers.oreilly.com/topic/163-how-to-calculate-the-interval-between-two-dates-or-times-in-mysql/ answers this succinctly. — krowe, Mar 28 '14 at 23:54
TIMESTAMPDIFF(MINUTE,(From_unixtime(q.paid_date)),(From_unixtime(q.closed_date))) — Alankar, Mar 29 '14 at 00:04

score 6 · Answer 1 · answered Mar 28 '14 at 23:59

Time difference in minutes:

SELECT ROUND(TIME_TO_SEC(timediff(date1,date2))/60) AS diff

Example:

SELECT ROUND(TIME_TO_SEC(timediff('2014-01-01 11:29:00','2014-01-01 07:27:21'))/60) AS diff

Result:

Time difference in hours:

SELECT ROUND(TIME_TO_SEC(timediff(date1,date2))/60/60) AS diff

if you need number of hours with fractions then remove ROUND.

1 Answers1