add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201)

[tt-rss.git] / xml-rpc.php

diff --git a/xml-rpc.php b/xml-rpc.php
index 07f423cbd492f3cba7cc28dd500ea526fa2fa2cb..0117657d0339944aa9b4ff71ba0af57730efab76 100644 (file)
--- a/xml-rpc.php
+++ b/xml-rpc.php
@@ -175,7 +175,7 @@
                if (authenticate_user($link, $login, $pass)) {
 
                        $result = db_query($link, "SELECT 
-                               id, feed_url, cat_id, title, SUBSTRING(last_updated,1,19) AS last_updated
+                               id, feed_url, cat_id, title, ".SUBSTRING_FOR_DATE."(last_updated,1,19) AS last_updated
                                        FROM ttrss_feeds WHERE owner_uid = " . 
                                $_SESSION["uid"]);
 
@@ -341,7 +341,7 @@
 
                        $query = "SELECT title,link,content,feed_id,comments,int_id,
                                marked,unread,
-                               SUBSTRING(updated,1,16) as updated,
+                               ".SUBSTRING_FOR_DATE."(updated,1,16) as updated,
                                author
                                FROM ttrss_entries,ttrss_user_entries
                                WHERE   id = '$article_id' AND ref_id = id AND owner_uid = " . $_SESSION["uid"] ;