Powered By Blogger

Thursday, August 13, 2015

time add in mysql query

SELECT SEC_TO_TIME( SUM( TIME_TO_SEC(  `bill_hours` ) ) ) AS timeSum,  `project_id` ,  `permalink` ,  `watchers_id` ,  `watchers_name`
FROM  `billable`
GROUP BY  `users_id` ,  `project_id`
LIMIT 0 , 30

No comments:

Post a Comment