My query works fine:
I convert SECONDS to TIME in the query, but the grid shows the time with 6 zeros.
¿How can I avoid that?
If you run this query in phpmyadmin or similar IDE, you might see same result data.
If you want only time, you can use substr function in sql. e.g.
SELECT i.id, invdate , c.name,
i.note, substr(sec_to_time(i.total),1,8) as total, i.closed
FROM invheader i
INNER JOIN clients c ON c.client_id = i.client_id
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!