My query works fine:
I convert SECONDS to TIME in the query, but the grid shows the time with 6 zeros.
example: 13:40:22.000000
¿How can I avoid that?
Thanks!
1 Answers
Hi,
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
Your Answer