[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
>> 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.

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 
release.  ;)

(In other words, doing so was far from trivial and determined to be more 
dangerous than beneficial.)


More information about the mythtv-users mailing list