title: How to store fractions of a second in mysql
body: <p>I would like to store time data accurate to the centisecond.  The <a href="http://dev.mysql.com/doc/refman/5.1/en/time.html" rel="nofollow noreferrer">mySQL manual</a> states that all stored values will be rounded.</p>
  
  <p>I see two decent options.  The time above the decimal place can be stored as TIME, and below the decimal can be stored as a TINYINT.  The other option might be to shift all the values up so that HH:MM:SS:cc becomes DD:HH:MM:SS.  Any other thoughts or criticisms?</p>
  
  <p>Thanks for the ideas.</p>
  
  <p>-Storm</p>