How to order items from Room database by date with "MMM dd yyyy" format

Question

I'm trying to order items by date from Room database, where the dates are stored as strings with this format MMM dd yyyy. Is there any way I could do this without changing structure of my database?

I tried @Query("SELECT * FROM table ORDER BY date") which just orders the months alphabetically.

score 2 · Accepted Answer · answered Oct 01 '19 at 14:08

2

I fixed my issue by changing my date format to from Jan 01 2019 to this format 2019 01, 01 and when retrieving from database, I order by the new date format.

NOTE: This might not be the best solution but it worked perfectly for what I'm trying to achieve.

answered Oct 01 '19 at 14:08

tony

466
6
22

can you see my question [link](https://stackoverflow.com/questions/58181364/how-to-order-room-results-by-date-as-string) – Nima Khalili Oct 01 '19 at 14:18
Don't you have same problem? – Nima Khalili Oct 01 '19 at 14:23
What exactly is the issue you're facing? – tony Oct 01 '19 at 14:34
If month has two digits come at first in sort – Nima Khalili Oct 01 '19 at 14:42
try taking out the `asc` from the query, might still not work but still. – tony Oct 01 '19 at 16:42
I found a solution , maybe help you [link](https://stackoverflow.com/questions/58181364/how-to-order-room-results-by-date-as-string/58203956#58203956) – Nima Khalili Oct 02 '19 at 14:50

How to order items from Room database by date with "MMM dd yyyy" format

1 Answers1