Example of LastModified timestamp in SQLite From http://stackoverflow.com/questions/2248432/does-sqlite-store-the-lastmodified-date-of-a-row

lastModified.sql

CREATE TRIGGER update_appInfo_updatetime  BEFORE update ON appInfo 
begin
update appinfo set updatedatetime = strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime') where bundle_id = old.bundle_id;
end

CREATE TABLE "appInfo" (bundle_id INTEGER PRIMARY KEY,title text, updatedatetime text DEFAULT (strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime')))