[mythtv-users] power search with maths (program duration)

[Tim Draper]

---- On Sat, 19 Sep 2015 10:38:57 +0100 Jan Ceuleers<jan.ceuleers at gmail.com> wrote ---- 
 > On 19/09/15 10:42, Tim Draper wrote: 
 > > I'm trying to setup a power search to only record the 1hour showings of a program. having taken a look in at the db via phpmyadmin, there does not appear to be a specific column with duration. I assume to calculate the duration, i need to subtract 'starttime' from 'endtime' from the program table. 
 > >  
 > > This is where i have issues. Not being familiar with sql or building queries, how would i do this? 
 >  
 > TIMESTAMPDIFF(MINUTE, program.starttime, program.endtime) can be 
 > compared to the desired number of minutes. For example 
 >  
 > TIMESTAMPDIFF(MINUTE, program.starttime, program.endtime) <= 65 
 >  
 > catches programs that last up to an hour and five minutes. 
 > _______________________________________________ 
 > mythtv-users mailing list 
 > mythtv-users at mythtv.org 
 > http://lists.mythtv.org/mailman/listinfo/mythtv-users 
 > http://wiki.mythtv.org/Mailing_List_etiquette 
 > MythTV Forums: https://forum.mythtv.org 
 > 

thanks for the help - my full rule now looks like which is excluding the 30/40 minute version and catching the the 1h/1h5mins showing - hope it helps someone else in the future... 

program.title LIKE 'Program Name' AND TIMESTAMPDIFF(MINUTE, program.starttime, program.endtime) BETWEEN 55 AND 65