In my query I have two columns where I make the sum of hours and the sum of the amount to be paid by the client at these times:
Line summing times: CAST(SUM(SEC_TO_TIME(E.teste1))/100 AS DECIMAL (15,2)) AS QTD 1º e 2º Hora
Line that adds the amount to pay: SUM(CONCAT(E.Valor, '€')) AS Valor 1º e 2º Hora
In mysql you are displaying the results as shown in the image:
When displaying query data in php I want to display the hour column in time format and the column that adds the value to pay with the euro symbol