csrchvz15
-
Posts
3 -
Joined
-
Last visited
Community Answers
-
csrchvz15's post in How do I format correctly a time Field in Jasper Reports ? was marked as the answer
After some search I've found out that, if you want to format time in MySQL and MariaDB this is the sentence you should use:
SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(TIEMPO_SOPORTE))) AS HorasSoporte FROM YOUR_TABLE