From a5813bb76699978fcaf7909796b1fbd953a4975b Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 9 Dec 2018 20:38:02 +0300 Subject: mysql: use date_format() for yyiw part in queryFeedHeadlines() --- classes/feeds.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/classes/feeds.php b/classes/feeds.php index 6a16cd85b..a79a1ebd2 100755 --- a/classes/feeds.php +++ b/classes/feeds.php @@ -1701,7 +1701,7 @@ class Feeds extends Handler_Protected { $yyiw_qpart = "to_char(date_entered, 'IYYY-IW') AS yyiw"; } else { $sanity_interval_qpart = "date_entered >= DATE_SUB(NOW(), INTERVAL 1 hour) AND"; - $yyiw_qpart = "concat(year(date_entered),lpad(weekofyear(date_entered), 2, '0')) AS yyiw"; + $yyiw_qpart = "date_format(date_entered, '%Y-%u') AS yyiw"; } if (!$search && !$skip_first_id_check) { -- cgit v1.2.3