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