HI Team,
Can anyone guide me how to convert "11 May 2021 07:08:12 GMT" of type varchar to DateTime type in mysql.
I have a column of timestamp of type varchar as I am dumping data directly from csv.
I need to do some group by and min , max based on data type datetime on this field.
Please guide
Regards
Bihitak
Discussion posts and replies are publicly visible
Hi, You can use convert() function probably once you are doing in db.one more thing you can do is, Before dumping it to db table , format the column as well into date time from string. In this case you wont have to convert in DB.