title: Can dates stored as string/text be compared directly?
body: <p>I'm working in SQLite so I'm storing dates as just text.</p>
  
  <p><code>YYYY-MM-DD hh:mm:ss</code></p>
  
  <p>As far as I can determine, I should be able to order them or compare them with each other just as they are not worrying about date functions since any incrementing starts right and moves left, just like numbers, and all the values are numeric, and the non-numeric characters are always standardized and I'm using 24-hour time.</p>
  
  <p>I keep seeing people online mentioning how dates as text have to be converted for any comparisons, but I don't see why they wouldn't just work as-is so long as they're in that greatest -> smallest order. Obviously I can't do math, but <code>Select DateTime From Table where DateTime &gt; 2010-04-21 15:34:55</code> should be totally reliable, right?</p>
  
  <p>Is there some exception I'm not thinking of?</p>