Time problem


with this code he reads the time from MYSQL which is stored in a time type but in the form of 00:00:00. how can I read this in hours and minutes 00:00 only.

$res = mysqli_query($conn,"SELECT * FROM openingsuur where open like '%open%'");
while($row= mysqli_fetch_array($res))
echo $row['dag'].' van ';
echo $row['openu'].'U'; // openU is now 00:00:00
echo $row['sluitu'].'U <br />';}

SELECT DATE_FORMAT(timeColumnNameHere, ā€œ%H:%iā€) as time

Sponsor our Newsletter | Privacy Policy | Terms of Service