Mysql calculate total minutes

Question

How to total the minutes of the two dates? I mean I want to know the total minutes between from 2012-01-08 8:30 and 2012-01-09 14:11 using MySQL?

I have initiate_date and finalize_date columns in my table and I want to select them and display their total minutes.

score 8 · Accepted Answer · answered Feb 01 '13 at 08:19

8

For example

TIMESTAMPDIFF(MINUTE, initiate_date, finalize_date)

answered Feb 01 '13 at 08:19

Moseleyi

score 4 · Answer 2 · edited Oct 28 '19 at 07:25

4

 SELECT (TIME_TO_SEC(end_time) - TIME_TO_SEC(start_time))/60 AS `minutes`

edited Oct 28 '19 at 07:25

Shahzad Barkati

answered Feb 01 '13 at 08:26

Devendra

2 Answers2