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

Wim w.f.mythbuster at gmail.com
Mon Nov 5 18:08:30 UTC 2012

Op 4-11-2012 23:11, Michael T. Dean schreef:
> 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.)
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users

My rule now looks like this and it works

program.title LIKE '%de wereld draait door%'
AND channel.callsign like '%ned%'
HOUR(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM'))>=19
AND HOUR(CONVERT_TZ(program.starttime, 'UTC', 'SYSTEM'))<=21

Can't say I think this is user friendly.


More information about the mythtv-users mailing list