title: SQLite order by Date with format EEE MMM dd HH:mm:ss zzz yyyy
body: <p>My date is being saved as a string in sqlite in the format "EEE MMM dd HH:mm:ss zzz yyyy". it is quite important that is saved this way.</p>
  
  <p>However, now I need to fetch the saved data from database whilst ordering them by date starting with the newest.</p>
  
  <pre><code>String selectQuery = "SELECT  * FROM " + InteractionSchema.TABLE +
                       " interaction " + " WHERE interaction." +
                       InteractionSchema.KEY_owner +
                       " =? ORDER BY datetime(" + InteractionSchema.KEY_date +
                       ") DESC LIMIT 15";
  </code></pre>
  
  <p>It is not working at all, I tried using all the other <a href="http://www.sqlite.org/lang_datefunc.html" rel="nofollow noreferrer">SQLite date function </a> but to no avail. I am pretty sure it has to do with the date format. Has anybody dealt with this before? (PS, it is not a duplicate I have already gone through similar questions on stackoverflow)</p>