How to guess or recover a timestamp conversion in sqllite?
The Unix epoch timestamp is defined as the number of seconds since the beginning of 1970 (in UTC).

These timestamps are measured from the beginning of 2001, and appear to use the respective local time zone:

&gt; select datetime(strftime('%s', '2013-11-10') - 405720000, 'unixepoch');
2001-01-01 04:00:00
&gt; select strftime('%s', '2013-11-10') - strftime('%s', '2001-01-01 04:00:00');
405720000


To correct for the random time zone differences, you should round to the nearest midnight.