[mythtv-users] MythTV does not handle daylight savings properly
Michael T. Dean
mtdean at thirdcontact.com
Sun Nov 4 22:11:59 UTC 2012
On 11/04/2012 11:54 AM, Brian J. Murrell wrote:
> Jonatan Lindblad wrote:
>> From http://www.mythtv.org/wiki/Release_Notes_-_0.26:
>> "Timesstamps that use local time in existing custom recording rules
>> 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.
ISTM that if you wanted code to just change users' custom rules (and
never break them), you could/should have written that code before the
(In other words, doing so was far from trivial and determined to be more
dangerous than beneficial.)
More information about the mythtv-users