Cast required

diff --git a/src/InfoCon/account/query.wml b/src/InfoCon/account/query.wml
index bc61e7d..a1fe496 100644 (file)
--- a/src/InfoCon/account/query.wml
+++ b/src/InfoCon/account/query.wml
@@ -75,7 +75,7 @@ input.submit:hover {
 <select id=year name=year>
 <option>
 <?
-  $query = "SELECT DISTINCT substr(datum,0,5) AS year FROM $table ORDER BY year DESC";
+  $query = "SELECT DISTINCT substr(datum::text,0,5) AS year FROM $table ORDER BY year DESC";
   $sth = pg_exec ($dbh, $query);
 
   for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {