Inserted date of record in sqlite3 database?

Question

Hello Guys,

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

Thanks in advanced.

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). http://stackoverflow.com/questions/1711504/how-get-datetime-column-in-sqlite-objecite-c/1711591#1711591