mysql值按日期排序，但此列类型不是日期类型

Question

i have a database values values like this format

premium_paid_date
31-10-17
30-10-17
11-10-18
31-08-18
31-10-17
25-11-17

but it was stored type is var-char. my customer wants this table ORDER BY year. which mean based on last two digits and followed by month and date. how can i order this using MySQL without convert into date format

Answer 1

You can convert string to date in your order by statement. Like

SELECT Premium_paid_date FROM Table_Name ORDER BY Convert( DateTime, premium_paid_date, 102) DESC

see date format