title: How do DATETIME values work in SQLite?
body: <p>I’m creating Android apps and need to save date/time of the creation record. The SQLite docs say, however, "SQLite does not have a storage class set aside for storing dates and/or times" and it's "capable of storing dates and times as TEXT, REAL, or INTEGER values".</p>
  
  <p>Is there a technical reason to use one type over another? And can a single column store dates in any of the three formats from row to row?</p>
  
  <p>I will need to compare dates later. For instance, in my apps I will show all records that are created between date A until date B. I am worried that not having a true DATETIME column could make comparisons difficult.</p>