[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%'
AND
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.
Wim
More information about the mythtv-users
mailing list