summaryrefslogtreecommitdiff
path: root/modules/pref-feed-browser.php
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2008-04-28 11:08:44 +0100
committerAndrew Dolgov <[email protected]>2008-04-28 11:08:44 +0100
commit2ac6b765ab62750fc8348d5bca1efbff9c42a71d (patch)
tree051beae9bbebfe842c291d5a1ecd6fbfec3dac68 /modules/pref-feed-browser.php
parente89aed7bb53760d27803a22c086893b0cd75233c (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.php4
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");