title: What is the appropriate date formatting so the lexicographic ordering is the same as time ordering?
body: <p>In my SQLite database, there is no <code>Date</code> datatype, so I have to store timestamps in text format.</p>
  
  <p>Does the format <code>yyyy-MM-dd HH:mm</code> result in the correct ordering such that when you sort it lexicographically (by doing a normal sort ASC or DESC), it also orders by time value inherently?</p>