I think that I'm not storing the date/time correctly, I don't think that it's UTC.
BTW, this might be useful in debugging:
sqlite3 ~/.local/share/me-tv/me-tv.db "select c.name, datetime(ee.start_time, 'unixepoch', 'localtime'), eet.title, eet.description from channel c, epg_event ee, epg_event_text eet where c.channel_id = ee.channel_id and ee.epg_event_id = eet.epg_event_id and description like '%Yachten%'"
The time shown here is actually UTC.
I think that I'm not storing the date/time correctly, I don't think that it's UTC.
BTW, this might be useful in debugging:
sqlite3 ~/.local/ share/me- tv/me-tv. db "select c.name, datetime( ee.start_ time, 'unixepoch', 'localtime'), eet.title, eet.description from channel c, epg_event ee, epg_event_text eet where c.channel_id = ee.channel_id and ee.epg_event_id = eet.epg_event_id and description like '%Yachten%'"
The time shown here is actually UTC.