title: sqlite datetime data type with iphone NSdate?
body: <p>Is there a way in sqlite to automatically save a timestamp in the table whenever a record has been created that I can then grab and save as an NSDate in my application?</p>
  
  <p>Or should I instead create the NSdate object with the current time  in my iphone app, and then insert it into the database. If so? What column should the datatype be for the time? a DATETIME?</p>