Is it possible to create a table with a hh:mm time column?

I want to create a table column that has a hh:mm format. How do I do that?

I’ve tried it with time(0) but that also gives me the seconds.

CREATE TABLE courseTimes (
  startingTime time(0),
  endingTime time(0)
);

​x
 
CREATE TABLE courseTimes (  startingTime time(0),  endingTime time(0));​

I want the entries to look like

startingTime 19:25

endingTime 20:10

for example.

Answer

You can retrieve the time and format it like this.

Select
 TIME_FORMAT(startingTime),'%H:%i' ),
 TIME_FORMAT(endingTime),'%H:%i' )

 
Select TIME_FORMAT(startingTime),'%H:%i' ), TIME_FORMAT(endingTime),'%H:%i' )​