id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 11600,canned_searches.conf.php New Titles Premieres fix for UTC local time comparison,mythtv01@…,Rob Smith,"The New Titles, Premieres search in mythweb does not find many new titles because in 0.26, the starttime is in UTC but originalairdate is left in local time. So this comparison fails: {{{ . ' AND DAYOFYEAR(program.originalairdate) =' . ' DAYOFYEAR(program.starttime))' }}} I have hacked my system to wrap a CONVERT_TZ around starttime but my php knowledge is terrible so I don't know how to look up what the correct local timezone conversion should be to supply a real patch. But I can confirm that doing this produces the right data for me, since this is my timezone: {{{ . ' AND DAYOFYEAR(program.originalairdate) =' . 'DAYOFYEAR(CONVERT_TZ(program.starttime,""GMT"",""America/Los_Angeles"")))' }}} ",Bug Report - General,closed,minor,unknown,Plugin - MythWeb,0.26,low,Won't Fix,mythweb canned_searches utc,,0