Report Designer, expression parameter

Hi, I’m trying to use an expression to transform seconds from a query to and especific format: “HH:mm:ss”.

Which is the best way to do this?

What RDBMS are you using (Microsoft SQL Server, MySQL, etc)? Doing this within the query is ideal, because then all the logic is in one place. There may even be a built in function in the DB to do this for you:

I’m using mysql. thanks for the answer, I changed the query to this:

SELECT SEC_TO_TIME(Sum(detenciones.tiempo_detenido)) AS Suma_tiempo_detenido
FROM detenciones

Now is working, thank you for the help PGriffith.

1 Like