[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