Time problem

hello,

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.
thanks

 include_once('db.php');
$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