Here is a table I am working with:
dates char 20
filename text 16
It basically logs date and filename a user uploads. However the "dates" field was originally set as Char type. If I do set the primary key as descending order, it sorts like this:
which is not the correct date order. The correct date order should be:
It didn't seem I can change the Char type to Datetime type. In this case, how can I sort the primary keys in descending date order?? Thank you very much!!