Remove seconds from time field?

Question

How do I remove seconds and only show hh:mm?

The field type is time. Eg:

SELECT opentime, closetime FROM hours

Result:
17:00:00  |  23:00:00
17:30:00  |  23:40:00

Answer 1

SELECT
  TIME_FORMAT(opentime, "%H:%i") as opentime,
  TIME_FORMAT(closetime, "%H:%i") as closetime
FROM hours;