I just enabled the SQL Logger Plugin in SQLite mode, and mostly it looks really straightforward. I noticed something interesting though: the event log and device history tables seem to be in different time zones. Is this intentional? Is there a way to get them to use the same time zone? (Besides telling my Mac to pretend it's in London. ) For instance, my event log says this:
18|2012-10-05 16:59:43|False|11|Sent INSTEON|"Deck Plants" on to 100
but the corresponding entry in the device history is this:
3|2012-10-05 23:59:44|100|True
Notice the 7 hour time difference (I live in California). Suggestions please?