Index: openacs-4/contrib/obsolete-packages/bboard/www/forum-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/www/forum-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/bboard/www/forum-oracle.xql	29 Jun 2001 20:37:18 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/bboard/www/forum-oracle.xql	14 Aug 2001 23:13:44 -0000	1.2
@@ -25,7 +25,7 @@
 	       to_char(last_reply_date,'MM/DD/YY hh12:Mi am') as last_updated
           from bboard_messages_all b, persons
           where forum_id = :forum_id
-	    and sent_date > case when :last_n_days = 0 then '1976-01-01' else sysdate - :last_n_days end
+	    and sent_date > case when :last_n_days = 0 then '1976-01-01' else to_char(sysdate - :last_n_days) end
 	    and person_id = sender
             and reply_to is null
 	order by sent_date desc