Incorrect times for many SMS messages

Using chatty v0.6. Many of my SMS messages have an incorrect time, specifically the hour. A good illustration is this data from chatty-history.db for a conversation with one person that spans about an hour:

thread_id	id	direction	local time			time
489		214	out		2022-05-26 14:33:09	1653593589
489		215	in		2022-05-26 14:38:19	1653593899
489		216	in		2022-05-26 08:45:52	1653572752
489		217	in		2022-05-26 14:53:00	1653594780
489		218	in		2022-05-26 08:53:12	1653573192
489		219	in		2022-05-26 09:38:09	1653575889
489		220	out		2022-05-26 15:40:42	1653597642

ā€œlocal timeā€ is a result of select datetime(messages.time, ā€˜unixepoch’,ā€˜localtime’). Note messages 216, 218, and 219. The hour should be greater by 6. Since the messages are displayed in time order, it sure makes the conversation hard to read!

I’m in US Central (UTC-6), though currently on DST with UTC-5. Before DST the hour was off by 7 instead of 6 so when it happens it always seems to be UTC offset + 1 hour.

thread_id	id	direction	local time			time
62		74	out		2022-02-21 17:43:53	1645487033
62		76	in		2022-02-21 10:45:46	1645461946
62		77	out		2022-02-21 17:45:48	1645487148
62		78	out		2022-02-21 17:47:04	1645487224
62		79	in		2022-02-21 10:50:00	1645462200
62		82	in		2022-02-21 10:54:35	1645462475
62		83	out		2022-02-21 18:17:57	1645489077

Messages 76, 79, 82 are off by 7 hours.

Is there any other info that would be useful for resolving this?

To instill a little fun paranoia, perhaps it NATO in Brussels releasing them back to you after they have read them?

Since they didn’t do them all, maybe they are not 100% effective?

2 Likes