title: In SQLite Order By Datetime desc returning wrong data
body: <p>I have one doubt in Sqlite.dteTime DataType is Varchar(200) in Table structure. I want to get result in order by Date Time. </p>
  
  <p><strong>"select dteTime from table ORDER BY  dteTime Desc",</strong> </p>
  
  <p><strong>getting result is</strong> </p>
  
  <p>"05/05/2015 12:38:43 PM"</p>
  
  <p>"05/05/2015 12:38:43 AM"</p>
  
  <p>"05/05/2015 10:57:04 AM"</p>
  
  <p>"05/05/2015 10:57:04 AM"</p>
  
  <p>"05/05/2015 10:51:25 AM"</p>
  
  <p>"05/05/2015 10:51:25 AM"</p>
  
  <p>"05/05/2015 04:38:35 PM"</p>
  
  <p>"05/05/2015 04:00:48 PM"</p>
  
  <p>"05/04/2015 11:38:43 PM"</p>
  
  <p><strong>Instead of this how can i get(Expected Result)</strong></p>
  
  <p>"05/05/2015 04:38:35 PM"</p>
  
  <p>"05/05/2015 04:00:48 PM"</p>
  
  <p>"05/05/2015 12:38:43 PM"</p>
  
  <p>"05/05/2015 10:57:04 AM"</p>
  
  <p>"05/05/2015 10:57:04 AM"</p>
  
  <p>"05/05/2015 10:51:25 AM"</p>
  
  <p>"05/05/2015 10:51:25 AM"</p>
  
  <p>"05/05/2015 12:38:43 AM"</p>
  
  <p>"05/04/2015 11:38:43 PM"</p>
  
  <p><strong>Any solution?</strong></p>