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 /backend.php | |
parent | f8232151a0a4bdd430e928d742686a2330e99d68 (diff) |
add workaround for psql 8.3 stricter typechecking on SUBSTRING() (refs #201)
Diffstat (limited to 'backend.php')
-rw-r--r-- | backend.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/backend.php b/backend.php index a7606c5b7..47c5529cd 100644 --- a/backend.php +++ b/backend.php @@ -359,11 +359,11 @@ print "<div class='infoBoxContents'>"; $result = db_query($link, "SELECT login, - SUBSTRING(last_login,1,16) AS last_login, + ".SUBSTRING_FOR_DATE."(last_login,1,16) AS last_login, access_level, (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE owner_uid = id) AS stored_articles, - SUBSTRING(created,1,16) AS created + ".SUBSTRING_FOR_DATE."(created,1,16) AS created FROM ttrss_users WHERE id = '$uid'"); |