[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