How do you calculate time difference between two columns in mysql?
Posted on 2015-02-11
I want to calculate by day how much time was used to do the tasks.
I have the following date time columns
When I run the query below I get the following results
Task completed Date Actioned
I need to calculate how much time was used in hours and minutes for each day.
So in the first row it will be 60 * Time used = total hour : minutes production
How is this done?
Count(data_discovered_theme_keywords.discovered_keyword_id) AS TASKS_Completed,
DATE_FORMAT(data_discovered_theme_keywords.drill_ended, '%Y-%m-%d') AS Date_Actioned
data_discovered_theme_keywords.drill_level = 1 AND
data_discovered_theme_keywords.drill_completed = 1
Group By DATE_FORMAT(data_discovered_theme_keywords.drill_ended, '%Y-%m-%d')