How to sort by date in this format?

Question

Yii

Hello! the date is stored in the database in this form - 07/17/2015. How to sort it in descending order? I do this: but it is sorted only by the day, not taking into account the month
->orderBy(['created_at'=>SORT_DESC])

Answer 1

Convert date using MySQL functions to DATE and then sort.