On Mon, Mar 14, 2016 at 10:52 AM, Richard Hipp <drh at sqlite.org> wrote: > I think your system clock was set incorrectly when you did the initial insert.
I'm running on localhost and did not touch the clock. The following is the result of a just inserted row: SELECT strftime('%s', ts ), ts, strftime( '%s', CURRENT_TIMESTAMP ), CURRENT_TIMESTAMP FROM ... 1457956766|2016-03-14 11:59:26|1457953182|2016-03-14 10:59:42 Any idea?