diff options
| author | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2008-04-21 05:53:19 +0100 |
| commit | fc2b26a6a27d19ecbfbb2202fd35b37568c65181 (patch) | |
| tree | f9123f21920265535bfab4987d8aac674bbbbe08 /mobile | |
| parent | f8232151a0a4bdd430e928d742686a2330e99d68 (diff) | |
add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201)
Diffstat (limited to 'mobile')
| -rw-r--r-- | mobile/functions.php | 4 |
1 files changed, 2 insertions, 2 deletions
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 |