![]() If you play around with the database schema, you may find a good way to filter your messages. This way you can actually filter your messages in more flexible way. You should get your messages now filtered! Or if you know a range of dates then you can also do this: sqlite> SELECT text, datetime(date, 'unixepoch', '+31 year') AS cDate FROM message WHERE cDate >= "" and cDate <= "" 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 |