]> code.delx.au - mediapc-tools/commitdiff
check-guide-data: reduce from 4 to 2 days for warning
authorJames Bunton <jamesbunton@delx.net.au>
Wed, 11 Apr 2018 00:28:34 +0000 (00:28 +0000)
committerJames Bunton <jamesbunton@delx.net.au>
Wed, 11 Apr 2018 00:28:34 +0000 (00:28 +0000)
check-guide-data

index af84ee3f1ddeee19552e1e4ce4d0a5befbc24ffd..5db1b1cf6726e15b867be9e1621bd30e00e326ed 100755 (executable)
@@ -13,5 +13,5 @@ where
 group by
     c.channum
 having
-    max(p.endtime) < date_add(current_date(), interval 4 day)
+    max(p.endtime) < date_add(current_date(), interval 2 day)
 ;" | mysql mythconverg