title: mySQL TIME with fractional seconds clipping after decimal
body: <p>I am trying to add stopwatch timing to a database in mySQL.  The docs for 5.6 state fractional seconds is now allowed.</p>
  
  <p>ref: <a href="http://dev.mysql.com/doc/refman/5.6/en/time.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.6/en/time.html</a></p>
  
  <p>But when I actually try and do it, the database clips the decimal part. I also noted that even though I choose the column type as <code>TIME(3)</code>, its put a <code>(HH:MM:SS)</code> next it.  Missing completely the fractional part.</p>
  
  <p>A user inputs the hours, minutes, seconds and milliseconds (hh:mm:ss.ms) and I remove the <code>:</code>, as per instructions.  No date is involved in this.  but it still clips off the end.</p>
  
  <p>How would I prevent this clipping, is it how the column is set up ?</p>
  
  <p>Thanks in advance.</p>