Something like:

SELECT doctor_id, SUM(minutes_spent) / 60 AS hours_spent
FROM that_table
GROUP BY doctor_id

Ideally I would do the math in my PHP script so that I won't have to mess with the queries every now and then. Customers have a mind of their own you know.

• Is there a way to calculate time differences in MySQL using one select

  I have a table containing the following: name type id : INT date1 : DATETIME date2 : DATETIME And I need to calculate the difference between date2 and date1. This is possible using the T…

• Is there a way with MySQL to include the time a query takes in the results table?

  I want to include the time it takes to run a query as part of the output. Is this possible? For example, this query: mysql> SELECT count(*) AS NumberOfUsers FROM mdl_user; +---------------+…

• is there a way to convert the time format in the mysql

  the date style stored in the database is as this : 1310783109 . eg: the date field is updatetime . when i using this: SELECT updatetime from node_software then in my template file i using …

• How can I get number of days, hours, minutes and second from now to a date-time given in the MySQL database?

  In my MySQL table I have a datatime column (the time is saved in the following format 2011-02-15 11:01:14 ). I extract this information with the PHP and print it to the user page. $results = mysq…

• Best way to query mysql for total time worked in a day

  I'm trying to come up with the best way to add the total time an employee was clocked in. The punch types are day in, break out, break in & day out . You would think I could just select * whe…

• How do I compare a datetime field to a time expressed in minutes using MySQL

  I want to select a row only if it is younger than a set time, in this case 5 minutes: I'm not sure how to tell MySQL that 5 is minutes, and not an int. As such, I can't do this: SELECT data from …

• What is the best way in MySQL to get how many hours old something is?

  I'm looking to run a query that uses how many hours old something is to give it a weight, so I'm hoping someone know a quick way to get how many hours old something is from the current date/time giv…

• Is there is any way to get the select Random Records using query from table in mySql

  Is there is any way to get the select Random Records using query from table in mySql.

• In a MySQL environment that is not strict, is there a way to test a query using strict?

  I know that there is STRICT_ALL_TABLES, but I am not the admin and absolutely cannot set that on the database. However, I was wondering if I could set that for a query, kind of like select SQL_NO_CA…

• Is there any way to implement a time based trigger in Mysql 5.1?

  Is there any way to implement a time based trigger in Mysql 5.1 i.e. it must run at 12H05 every day Edit A corn job calling an SQL script is currently been used - but I am looking for a l…