How to use time_format() in Mysql?

Question

I made a table like this:

create table tabela (
hora time not null
);

This table returns me hour, minute and second. How is the table with time_format()? I want to leave it with the time and the second. My doubt is in the syntax (way to assemble the team).

Value returned: 00:00:00. Value I want you to return: 00:00.

Reason: I’m capturing the time of an HTML form (00:00) and saving it in the database. When the time is sent from the form to the database, the database stores it like this: 00:00:00. That’s why I want the team to accept this format when creating the table: 00:00.

Answer 1

The time_format() receives first the field and then the formatting parameters, to display time and second would look like this:

select TIME_FORMAT(hora, '%H:%s') from tabela

By way of doubt, also follows how to display hour and minutes:

select TIME_FORMAT(hora, '%H:%i') from tabela

I put in the Sqlfiddle for future reference