title: GET milliseconds with DATE_FORMAT in mysql
body: <p>I want to return a date with a certain format, for the moment I'm using: </p>
  
  <pre><code>SELECT DATE_FORMAT(NOW(3),'%y-%m-%d %H:%i:%s.%f')
  </code></pre>
  
  <p>which returns:</p>
  
  <pre><code>18-02-26 11:22:07.617000
  </code></pre>
  
  <p>that's perfect for now, however, I want to get Milleseconds, which means only 3 characters after the seconds, something like: <code>18-02-26 11:22:07.617</code> and I'm obliged to do it with <code>DATE_FORMAT</code>.</p>
  
  <p>Do you have any idea?</p>