If you know the exact date of the message you can replace the >= with = like this: sqlite> SELECT text, datetime(date, 'unixepoch', '+31 year') AS cDate FROM message WHERE cDate = "" Replace this "" with the date you want to filter your messages, but keep the ""! Sqlite> SELECT text, datetime(date, 'unixepoch', '+31 year') AS cDate FROM message WHERE cDate >= "" Now you are in the database of the Messages app of your mac.Įnter the following commands (but don't include the sqlite> as this one was added to this answer just to show you what you will expect at this point): sqlite>. ![]() The flexible wayĪnd enter the following command: sqlite3 ~/Library/Messages/chat.db ![]() ![]() Depending on your needs and preferences, you choose what you want.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |