Inserted date of record in sqlite3 database?

Question

I inserted a record in an sqlite3 database. I want to know the date on which that table inserted in database.

Answer 1

sqlite3 does not store change dates automatically, so if you want to get them later you should insert the date to database yourself.

Answer 2

The SQLite function julianday('now') will return a floating point value that represents the current date and time. This can be used in an insert.

You may also want to check out this question and its answer(s). How get a datetime column in SQLite with Objective C