I have a column named Install_date of type char(15) with dates written in this format: "5-Nov-17"
What's the easiest way to convert that column to a date type so that I can sort it please?
Asked
Active
Viewed 32 times
0
-
1`str_to_date(install_date, '%e-%b-%y')` – Madhur Bhaiya Dec 29 '19 at 04:35
-
@MadhurBhaiya long time no see! – Nick Dec 29 '19 at 05:05
-
1@Nick yeah.. busy with some new product development.. posted a question couple of days back: https://stackoverflow.com/q/59499000/2469308 – Madhur Bhaiya Dec 29 '19 at 09:03
1 Answers
0
select STR_TO_DATE("5-Nov-17","%d-%M-%y")
https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=cabdc038d3653e072fcb37454b769983
Frederic
- 1,018
- 6
- 11