diff options
| author | Andrew Dolgov <[email protected]> | 2018-12-09 20:38:02 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2018-12-09 20:38:02 +0300 |
| commit | a5813bb76699978fcaf7909796b1fbd953a4975b (patch) | |
| tree | b64891cccd8ae150685a7f85a3b0a36988590076 /classes/feeds.php | |
| parent | bea6e81d911193f0bcc62c3710453f5a72e0305c (diff) | |
mysql: use date_format() for yyiw part in queryFeedHeadlines()
Diffstat (limited to 'classes/feeds.php')
| -rwxr-xr-x | classes/feeds.php | 2 |
1 files changed, 1 insertions, 1 deletions
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) { |