title: How to order items from Room database by date with "MMM dd yyyy" format
body: <p>I'm trying to order items by date from Room database, where the dates are stored as strings with this format <code>MMM dd yyyy</code>. Is there any way I could do this without changing structure of my database?</p>
  
  <p>I tried <code>@Query("SELECT * FROM table ORDER BY date")</code> which just orders the months alphabetically.</p>