Me TV

  1. Bug #503051
  2. Comment #16

Comment 16 for bug 503051

Revision history for this message
Michael Lamothe (lamothe-deactivatedaccount-deactivatedaccount) wrote :

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.