how to convert from VARCHAR to DATATIME in MYSQL

1

In my record table, I have a column called date, but I have imported data (15000 data) and at the time of saving it has been saved like this:

01/01/2018 0:09:07 - > but in type VARCHAR (100)

I would like to know how I can modify that column and convert to DATATIME

    
asked by kev 08.05.2018 в 19:41
source

0 answers