Convert date to a valid timestamp

[The Little Guy]

I need to convert a column to a timestamp, anyone know of a good way to do this with out losing the dates (times don't matter)?

 

The current format is like so: mm/dd/yyyy

[fenway]

STR_TO_DATE() -- but don't store DATE values in CHAR fields.

[The Little Guy]

Will this work:

 

UPDATE comments SET STR_TO_DATE(date,'%m/%d/%Y')

 

date is the column name

[fenway]

You can -- and should -- easily check with an equivalent select.  And don't use a reserved keyword for a column name.