query to format dates on MySQL
Posted on 2014-10-07
I am familiar with MS SQL but not sure about MySQL.
I have a field which is currently a varchar255 and holds dates in the following format:
Mon - Jun 28, 02:51 pm
I tried to just change the field type to 'datetime' but I get an error and it won't let me.
How can I format the field so that it is in a format that allows me to change the field to "datetime"
the table name is: 'emails'
the field name is: Created Date'