From fc2b26a6a27d19ecbfbb2202fd35b37568c65181 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 21 Apr 2008 05:53:19 +0100 Subject: add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201) --- modules/pref-feed-browser.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/pref-feed-browser.php') diff --git a/modules/pref-feed-browser.php b/modules/pref-feed-browser.php index e33103501..bdbb930d4 100644 --- a/modules/pref-feed-browser.php +++ b/modules/pref-feed-browser.php @@ -16,7 +16,7 @@ $result = db_query($link, "SELECT feed_url,site_url, - SUBSTRING(last_updated,1,19) AS last_updated + ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated FROM ttrss_feeds WHERE id = '$id' AND auth_login = '' AND auth_pass = '' AND private IS NOT true"); -- cgit v1.2.3