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) --- mobile/functions.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mobile') diff --git a/mobile/functions.php b/mobile/functions.php index fe9dab4ed..b1085b9c5 100644 --- a/mobile/functions.php +++ b/mobile/functions.php @@ -113,7 +113,7 @@ } $result = db_query($link, "SELECT ttrss_feeds.*, - SUBSTRING(last_updated,1,19) AS last_updated_noms, + ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated_noms, (SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries WHERE feed_id = ttrss_feeds.id AND ttrss_user_entries.ref_id = ttrss_entries.id AND @@ -601,7 +601,7 @@ $result = db_query($link, "SELECT title,link,content,feed_id,comments,int_id, marked,published, - SUBSTRING(updated,1,16) as updated, + ".SUBSTRING_FOR_DATE."(updated,1,16) as updated, (SELECT icon_url FROM ttrss_feeds WHERE id = feed_id) as icon_url, num_comments, author -- cgit v1.2.3