<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Mon, Sep 29, 2014 at 8:16 AM, Brian J. Murrell <span dir="ltr"><<a href="mailto:brian@interlinx.bc.ca" target="_blank">brian@interlinx.bc.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Mon, 2014-09-29 at 10:38 -0400, Michael T. Dean wrote:<br>
<br>
> None required (or recommended). You can use Custom Priorities.<br>
<br>
How do I to time-of-day/day-of-week clauses in those rules? i.e. Sunday<br>
evening from 6pm until 11pm. Something like:<br>
<br>
DAYOFWEEK(CURDATE()) = 1 AND HOUR(CURTIME()) > 18 and HOUR(CURTIME() < 23<br>
<br>
perhaps? So altogether:<br>
<br>
channel.callsign = "WWNY" and DAYOFWEEK(CURDATE()) = 1 AND<br>
HOUR(CURTIME()) > 17 AND HOUR(CURTIME()) < 24<br>
<br>
Yes?<br>
<br>
Cheers,<br>
b.<br></blockquote></div><br></div><div class="gmail_extra">I know you already found the root of your issue but I wanted to mention that the powerpriority rules match against *program* entries, so you wouldn't use CURDATE(), you'd use starttime (or possibly program.starttime if it's ambiguous). And since all the mythtv times are in UTC, you'd use CONVERT_TZ(starttime,'UTC','SYSTEM'). So your full powerpriority selectclause would look something like this:<br><br>channel.callsign = 'WWNY' AND DAYOFWEEK(CONVERT_TZ(starttime,'UTC','SYSTEM')) = 1 AND HOUR(CONVERT_TZ(starttime,'UTC','SYSTEM')) BETWEEN 18 AND 23<br><br></div><div class="gmail_extra">You don't have to use the BETWEEN clause. It's just a handy shortcut for >=18 and <=23.<br><br></div><div class="gmail_extra">Karl<br></div></div>