Search code examples
messagemacos-high-sierra

High Sierra Chat.db Timestamp

I'm going to chat.db to get messages on a application (Mac OS).

Before Sierra in my SQL SELECT I was using datetime(date, 'unixepoch', 'localtime') to convert the timestamps.

Now on High Sierra it's not working, I get nothing.

It's seems the timestamps change... more digit like this: 531651854330806016

Does anybody know how to convert this?

Solution

  • Looks like Date fields are now nanosecond fields as per https://apple.stackexchange.com/questions/114168/dates-format-in-messages-chat-db

    So you can try this: datetime(date/1000000000, 'unixepoch', 'localtime')