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?