Report Designer, expression parameter

Ignition
1

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?

2

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:
https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_sec-to-time

3

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