SQLite: Default a datetime field to the current time (now)
SQLite FAQ: How do I default a SQLite datetime field to the current date and time? (i.e., how do I default it to now?)
Solution
Just use the SQLite current_timestamp
function to default a field to the current date and time, like this: