title: How to convert millsec to MYSQL datetime
body: <p>Hi I have date column as a string as below</p>
  
  <pre><code>Date
  2015-10-08 12:06:00.000
  2016-12-10 18:40:25.417
  2016-12-10 18:40:25.430
  2015-10-08 12:20:00.000
  </code></pre>
  
  <p>I am trying to convert the above column as datetime..</p>
  
  <pre><code>select str_to_date (Date,"%Y-%m-%d %H:%i:%s") as Date1 from tab;
  </code></pre>
  
  <p>throwing an error "Error Code: 1292. Truncated incorrect datetime value" </p>
  
  <p>Any modification in the above select statement.
  Thanks in advance.</p>