[mythtv-users] MythTV does not handle daylight savings properly

Brian J. Murrell brian at interlinx.bc.ca
Sun Nov 4 16:54:16 UTC 2012



Jonatan Lindblad <mythtv at comhem.se> wrote:
>
> From http://www.mythtv.org/wiki/Release_Notes_-_0.26:
>
>"Timesstamps that use local time in existing custom recording rules
>must 
>be manually changed to UTC. 

Is this just a one time transition issue and all future custom recording rules can just use regular time stamp rules without any need for CONVERT_TZ()?

>Examples: A rule with starttime='2012-09-12
>10:00:00', should be changed to starttime=CONVERT_TZ('2012-09-12 
>10:00:00', 'UTC', 'SYSTEM'). A rule with: HOUR(program.endtime) < 22 
>becomes HOUR(CONVERT_TZ(program.endtime, 'UTC', 'SYSTEM')) < 22. Note 
>that dates such as originalairdate do not factor in timezone offsets, 
>and will be the local date."

ISTM that if this was an across the board change for existing custom record rules, it could/should have been handled by the upgrade.

b.


More information about the mythtv-users mailing list