Hello, When working with Apple iOS databases, I found something strange when dealing with dates. Apple iOS databases store dates as seconds from 2001-01-01 (31 years after unix epoch). But from 2015-03-02 to 2016-02-29 there is a offset of one day if '31 years' modifier is used. To reproduce, execute the following query:
select datetime(446860801, 'unixepoch', '31 years') as date1, datetime(446860801+60*60*24, 'unixepoch', '31 years') as date2, datetime(446860801+60*60*24*2, 'unixepoch', '31 years') as date3 date2 should be 1 day after date1, but shows as the same date! Best regards, Fábio Pfeifer _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users