title: how to add hours ,minutes or seconds in 'TIME' Datatype in mysql
body: <p>I want to add hours or minutes in TIME datatype (no DATE in here) in MySQL:</p>
  
  <pre><code>create table table1(
      arrival_time TIME
  );
  </code></pre>
  
  <p>Here is the case in which the problem is, after <code>23:59:59</code> in <code>arrival_time</code>, if I add 1 hour , it should display <code>00:59:59</code>, not <code>24:59:59</code>.</p>
  
  <p>I have tried many functions like <code>addtime()</code>, <code>date_add()</code> and all but doesn't work with the above requirement.</p>