All ideas
str_to_date
In case study 1 , I followed all the steps from the guide video. When i used the update function it asked me to disable the safe mode. So I tried using cast and strtodate function to change into date format but the column shows null value. Please suggest a way to clear this. I have attached a picture of the cast and strtodate function I used. select * from users; alter table users add column tempcreatedat datetime; update users set tempcreatedat = strtodate(created_at, '%d-%m-%y %h:%i'); alter table users drop column created_at; alter table users change column tempcreatedat created_at datetime;
