[mythtv-users] more scheduler options

[Scott Blachowicz]

"Brett Kosinski" <fancypantalons at gmail.com> wrote:

> Well, it's pretty easy to achieve this using a power search.  Of course, if
> you lack SQL knowledge, that might be a little more tricky.  But something
> like this will do:
> 
> Between 8 and 10pm:
> 
> program.title = "Program Title" and
> hour(program.starttime) >= 20 and
> hour(program.starttime) <= 22

Not exactly...that would pick up start times before 20:00 and 22:59 inclusive.

Either this to get start times from 8:00pm through (but not including) 10:00pm:

    program.title = "Program Title" and
    hour(program.starttime) >= 20 and
    hour(program.starttime) < 22

Or maybe something like this instead if you want to include 10:00pm start times, but any other 10:xx start
times:

   program.title = "Program Title" AND
   hour(program.starttime) >= 20 AND
   (hour(program.starttime) < 22 OR
    (hour(program.starttime) = 22 AND minute(program.starttime) <= 0))

Scott