title: How to store time greater than 24 Hours in Mysql?
body: <p>I need to create a column (say <code>idletime</code>) that will store time value having hours smaller or bigger than 24. When i try to insert such values bigger than 24 (For
  example '80:00:00', '129:23:12', etc) , am getting the following error code:</p>
  
  <pre><code>java.sql.SQLException: Illegal hour value '80' for java.sql.Time type in value '80:00:00.
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
  .....
  </code></pre>
  
  <p>I have searched over the Internet and found that the TIME datatype ranges from 00:00:00 to 23:59:59 and  does not reach 24:00:00.</p>
  
  <p>Is there any solution available for my problem? Am executing this insert query within a stored procedure.</p>