[mythtv-users] power search help needed

[David Engel]

On Mon, Dec 03, 2012 at 12:27:27PM +0100, Udo van den Heuvel wrote:
> 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 )

Neither.  Why are you using HOUR()?  I think you should only need to
add CONVERT_TZ() to program.starttime as in:

(channel.callsign = "NL1" OR channel.callsign = "NL2" OR
channel.callsign = "NL3") AND CONVERT_TZ(program.starttime, 'UTC',
'SYSTEM') < DATE_ADD( NOW( ) , INTERVAL 9 HOUR )

Or simply keep everything in UTC as in:

(channel.callsign = "NL1" OR channel.callsign = "NL2" OR
channel.callsign = "NL3") AND program.starttime < DATE_ADD( UTC_TIMESTAMP( ) ,
INTERVAL 9 HOUR )

David
-- 
David Engel
david at istwok.net