[mythtv-users] Can't playback recorded shows but preview works - SOLVED

[Michael T. Dean]

On 05/09/2008 06:16 AM, Mike Holden wrote:
> The "usual" method for dealing with multiple timezones and databases is to
> accept a date/time from a user (or other source, xmltv in this case),
> convert it from "local" time (relevant to that client's location) to UTC
> and store it in the database. All calculations are then performed using
> date/time data in UTC. Whenever a date/time needs to be displayed to the
> user, then a conversion from UTC to the client's TZ is performed.
>
> The crucial aspect is that all dates are stored and processed in a common
> TZ, typically UTC (but could be any other TZ, another common choice is the
> TZ of the "server", the master BE here). This means that the only time you
> need TZ info is when converting dates from one TZ to another (at input or
> output only), and there are Posix etc programming APIs to do this for you,
> so you don't need to worry about the mechanics of it, or storing
> conversion tables etc.
>
> Of course, if the system wasn't designed that way in the first place, then
> retro-fitting TZ manuipulation is a total mess, and will need changes all
> over the place.
>   

As I mentioned, patches will be considered (but may be rejected due to 
the increased complexity of interpreting data when reviewing bug reports 
from users).

Mike