[mythtv-users] Changing Timestamps (or fixing listing times)

[Neil Konouchi]

Hi, I moved over to .15.1 with no major problems, but I have one small snaggle that I'm not sure how to handle. I live in Nashville (which is Central time). When I set up the box that eventually became my MythTV box, I used to live in Boston (EST) and never bothered changing the time zone setting. When I grabbed the listings via XMLTV, things were fine, but I guess that DataDirect uses GMT offset rather than literal time. After upgrading and getting listings via DD, everything was off by an hour. Changing my time zone setting to Central and re-running mythfilldatabase got all the listings correct, so that solves that much of the problem.

The trouble is that now all my timestamps are off by an hour in the "recorded" table in MySQL for the existing recordings. So when Myth goes to look for a file that was originally recorded May 1, 2004 at 3pm, it looks for 20040501140000 (14:00 hours), but the filename was recorded as 20040501150000 (15:00 hours). 

Is there a command I can run in MySQL to add an hour to each timestamp in the "recorded" table? Or would it be easier to just set some sort of offset in the new listings? I tried messing around with the XMLTV offset setting in the setup program, but I suppose that doesn't effect listings grabbed from DD since it didn't seem to make any difference.

...seems like this could be a problem if anyone moved and took their Myth box with them to a new time zone, too. Any help?

Neil K