Change a datetime data content in a string into a datetime mysql format in php

[danielchen]

Hallo Everybody,

 

Can anybody help me to change a datetime data content into another new column with a datetime mysql format...

I attach more information in the follow images...thanks in advance for the help

[Barand]

Being from the UK I assume your current dates are dd/mm/yyyy (impossible to tell from your date samples) so adjust as necessary.

UPDATE tablename 
SET fecha = STR_TO_DATE(`Date/Time`, '%d/%m/%Y %H:%i:%s')

Edited June 2, 2015 by Barand

[danielchen]

It worked thank you so much...Barand