Glossary
Mac Absolute Time (Cocoa Time)
Mac Absolute Time, or Cocoa / Core Data time, counts seconds since 2001-01-01 UTC. Add 978307200 for Unix time; some iOS databases store nanoseconds.
Mac Absolute Time, also called Cocoa time, Core Data time or Apple epoch time, counts seconds since 2001-01-01 00:00:00 UTC. It is the default timestamp format of Apple's frameworks, so most iOS databases use it: knowledgeC.db, CallHistory.storedata, Photos.sqlite, Safari's History.db and the routined databases behind Significant Locations.
To convert to Unix time, add 978307200, the number of seconds between 1970-01-01 and 2001-01-01:
SELECT datetime(ZDATE + 978307200, 'unixepoch') FROM ZCALLRECORD;
Watch the unit. Values are often floating point with fractional seconds, and some databases store nanoseconds instead: the date columns of sms.db on current iOS versions must be divided by 1,000,000,000 first. A value around 7 × 10^8 is seconds (a date in the 2020s); a value around 7 × 10^17 is nanoseconds.
Stored values are UTC. The device's local offset, when kept at all, sits in a separate column such as ZSECONDSFROMGMT. Do not confuse Cocoa time with Unix time (1970), WebKit or Chrome time (microseconds since 1601) or GPS time.