I'm trying to extract the chat history between myself and my SO on Skype for OSX. I've managed to pull out the information and strip out the unnecessary XML formatting with the following command:
sqlite3 /path/to/main.db "SELECT author,timestamp, body_xml FROM messages WHERE dialog_partner = 'so_username'" | sed -e 's/<[^>]*>//g' - > output.txt
This seems fine, but what I notice is that the timestamps in the output file are in some bizarre non-human readable format. Is there a way I can parse these?