title: milliseconds in mysql
body: <p>This page explains how to format milliseconds
  <a href="http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_now" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_now</a></p>
  
  <p>but how do I get the actual millisecond value beyond just .00000?</p>
  
  <p>I've tried these:</p>
  
  <pre><code>  select unix_timestamp()+0;
    select SYSDATE()+0;
    select date_format(now(), '%f');
    select now()+0;
  </code></pre>
  
  <p>but none of theme give me precise and accurate milliseconds</p>