From 8c595dd30fb9fddf8d71d8ac9daea8cef4e85e49 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 31 Jul 2014 11:28:44 -0400 Subject: [PATCH] Bug 12507 - Don't show News in Staff and opac --- C4/NewsChannels.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/NewsChannels.pm b/C4/NewsChannels.pm index 47772ef..8694c1b 100644 --- a/C4/NewsChannels.pm +++ b/C4/NewsChannels.pm @@ -197,7 +197,7 @@ sub GetNewsToDisplay { OR expirationdate IS NULL OR expirationdate = '00-00-0000' ) - AND `timestamp` < CURRENT_DATE()+1 + AND DATE(timestamp) < DATE_ADD(CURDATE(), INTERVAL 1 DAY) AND (lang = '' OR lang = ?) AND (branchcode IS NULL OR branchcode = ?) ORDER BY number -- 1.7.2.5