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
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?