title: Persisting Dates to SQLite3 in an iPhone Application
body: <p>I am developing an iPhone application that persists data to a SQLite3 database. </p>
  
  <p>For each row I persist I wish to include a 'created date' and a 'last modified date'</p>
  
  <p>My question is what is the recommend approach for storing this information in a table? </p>
  
  <p>The properties are represented as NSDate in my application but I am unsure how to represent this information in my table.</p>
  
  <p>It appears that SQLite3 provides a DATETIME type but does not have a native understanding of how to parse this information.</p>
  
  <p>Any help would be much appreciated.</p>
  
  <p>Thanks in advance.</p>