From 2ac6b765ab62750fc8348d5bca1efbff9c42a71d Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 28 Apr 2008 11:08:44 +0100 Subject: more work on PGSQL 8.3 compatibility (refs #201) --- modules/pref-feed-browser.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'modules/pref-feed-browser.php') diff --git a/modules/pref-feed-browser.php b/modules/pref-feed-browser.php index bdbb930d4..a80109bc5 100644 --- a/modules/pref-feed-browser.php +++ b/modules/pref-feed-browser.php @@ -44,8 +44,8 @@ $result = db_query($link, "SELECT ttrss_entries.title, content,link, - substring(date_entered,1,19) as date_entered, - substring(updated,1,19) as updated + ".SUBSTRING_FOR_DATE."(date_entered,1,19) as date_entered, + ".SUBSTRING_FOR_DATE."(updated,1,19) as updated FROM ttrss_entries,ttrss_user_entries WHERE ttrss_entries.id = ref_id AND feed_id = '$id' ORDER BY updated DESC LIMIT 5"); -- cgit v1.2.3