title: Sqlite Sort by time not working
body: <p>I am storing date format  in sqlite table, I want sort by date from table. </p>
  
  <p>Every record in my SQLite database contains a column which contains a date stored as a string in the format 'yyyy-MM-dd HH:mm:ss'.</p>
  
  <p>I am sharing my table structure. I am using this query to <strong>sort by datetime</strong> it not sorting by time but sort by date is working fine.</p>
  
  <pre><code>select * 
  from messages_table 
  where id = '444' 
  order by datetime(date_time) asc
  </code></pre>
  
  <p>I am storing <code>datetime</code> as string in my below table</p>
  
  <p><a href="https://i.stack.imgur.com/Z9QQL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Z9QQL.png" alt="enter image description here"></a></p>
  
  <p>and I am getting the below wrong sorting by time output please see my date_time column in the picture, anyone guide me.</p>
  
  <p><a href="https://i.stack.imgur.com/CuKmZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CuKmZ.png" alt="enter image description here"></a></p>