On Nov 20, 2018, at 12:41 PM, Jens Alfke <[email protected]> wrote:
> On Nov 20, 2018, at 11:44 AM, Bill Hashman <[email protected]>
> wrote:
>
>> The timestamp from iOS systems is not compliant with ISO 8601/Unix or other
>> common timestamps. It appears apple has their start date offset 31 years.
>
> Yes, the ‘epoch’ in Apple’s own APIs (CoreFoundation, Foundation) is
> 1/1/2001, expressed as a double. But of course the POSIX APIs on Apple
> platforms use the regular Unix epoch of 1/1/1970 as integer.
That database looks like it was produced by Core Data, which does not use
SQLite's timestamp-specific features since NSDate and friends are backed by
doubles.
For Bill's purposes—investigating a copied, non-corrupt database—it would
probably be easiest to just convert from the Cocoa epoch to the Unix epoch by
updating all the columns that currently store Cocoa timestamps. Something like:
UPDATE ZTIMEENTRY SET ZDATE = ZDATE + 978307200;
Scott
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
