title: subtract minutes from a time value
body: <p>I have a time field in my database, it has the value 22:05</p>
  
  <p>I want to subtract 5 minutes. When the field is datetime I use sub_date and works fine, but I can't get it with time field, I get a warning I don't know how to deal with;</p>
  
  <pre><code>mysql&gt;  SELECT scheduleFinalTime FROM clientSchedule WHERE clientScheduleID = 3;
  +-------------------+
  | scheduleFinalTime |
  +-------------------+
  | 22:05:00          |
  +-------------------+
  1 row in set (0.00 sec)
  
  mysql&gt; SELECT date_sub(scheduleFinalTime, INTERVAL 5 MINUTE) FROM clientSchedule WHERE clientScheduleID = 3;
  +------------------------------------------------+
  | date_sub(scheduleFinalTime, INTERVAL 5 MINUTE) |
  +------------------------------------------------+
  | NULL                                           |
  +------------------------------------------------+
  1 row in set, 1 warning (0.00 sec)
  
  mysql&gt; show warnings;
  +---------+------+------------------------------------------------------------+
  | Level   | Code | Message                                                    |
  +---------+------+------------------------------------------------------------+
  | Warning | 1264 | Out of range value for column 'scheduleFinalTime' at row 1 |
  +---------+------+------------------------------------------------------------+
   1 row in set (0.00 sec)
  </code></pre>
  
  <p>Thank you in advance</p>