title: Convert String to Datetime Object in SQL
body: <p>I'm using <strong>MySQL 5.6</strong> and I have datetime stamps like one of this: <code>2015-01-28 08:30:02:843000</code>. Currently,  they are stored as strings.  I tried to alter the table to make this into datetime objects but the command failed. I'm rough with SQL, what would be the query to convert these to datetime objects? Do I need to remove the milliseconds somehow? Or convert the last colon to a period?</p>