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

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'");