I need to save only hour and minutes (seconds do not make a difference, so have or do not), should I use TIME
or TIMESTAMP
?
I started to do with TIMESTAMP(6)
, but I'm having a hard time doing insert
, what should I do?
My insert:
INSERT INTO EXEMPLO (DESCRICAO, NUMEROMAXIMO, HORAENTRADA, HORASAIDA)
VALUES ('Descrição', '50', '15:51:00', '16:51:00');