title: How to create a mysql table that stores time (hours and minutes)?
body: <p>I'd like to create a mysql table that stores time (hours and minutes), such as 456:45 (456 hours and 45 minutes)</p>
  
  <p>CREATE TABLE mytable(id VARCHAR(40) NOT NULL, my_time DATE NOT NULL);</p>
  
  <p>which data type should be used?</p>