diff options
author | Andrew Dolgov <[email protected]> | 2008-04-28 11:08:44 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-04-28 11:08:44 +0100 |
commit | 2ac6b765ab62750fc8348d5bca1efbff9c42a71d (patch) | |
tree | 051beae9bbebfe842c291d5a1ecd6fbfec3dac68 /modules/pref-feed-browser.php | |
parent | e89aed7bb53760d27803a22c086893b0cd75233c (diff) |
more work on PGSQL 8.3 compatibility (refs #201)
Diffstat (limited to 'modules/pref-feed-browser.php')
-rw-r--r-- | modules/pref-feed-browser.php | 4 |
1 files changed, 2 insertions, 2 deletions
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"); |