[mythtv-users] MythTV does not handle daylight savings properly
Jonatan Lindblad
mythtv at comhem.se
Sun Nov 4 13:27:17 UTC 2012
On 2012-11-04 14:13, Wim wrote:
> Hello
>
> I have I few power search rules like below.
>
> program.title LIKE '%de wereld draait door%'
> AND channel.callsign like '%ned%'
> AND HOUR(program.starttime)>=19
> AND HOUR(program.starttime)<=21
>
> But after the stat off wintertime last weekend.
>
> I had to change the rule like this.
>
> program.title LIKE '%de wereld draait door%'
> AND channel.callsign like '%ned%'
> AND HOUR(program.starttime)>=18
> AND HOUR(program.starttime)<=20
>
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. 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."
--
Jonatan
More information about the mythtv-users
mailing list