[mythtv-users] power search help needed
Udo van den Heuvel
udovdh at xs4all.nl
Mon Dec 3 11:27:27 UTC 2012
Hello,
In my power search I have a rule like:
(channel.callsign = "NL1" OR channel.callsign = "NL2" OR
channel.callsign = "NL3") AND program.starttime < DATE_ADD( NOW( ) ,
INTERVAL 9 HOUR )
How do I make this rule UTC compatible?
Is this OK?
(channel.callsign = "NL1" OR channel.callsign = "NL2" OR
channel.callsign = "NL3") AND HOUR(CONVERT_TZ(program.starttime, 'UTC',
'SYSTEM')) < DATE_ADD( NOW( ) , INTERVAL 9 HOUR )
Or should it be:
(channel.callsign = "NL1" OR channel.callsign = "NL2" OR
channel.callsign = "NL3") AND HOUR(CONVERT_TZ(program.starttime, 'UTC',
'SYSTEM')) < HOUR(CONVERT_TZ(DATE_ADD( NOW( ), 'UTC', 'SYSTEM')) ,
INTERVAL 9 HOUR )
?
Kind regards,
Udo
More information about the mythtv-users
mailing list