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.2 -r1.3
--- openacs-4/contrib/obsolete-packages/bboard/www/forum-oracle.xql	14 Aug 2001 23:13:44 -0000	1.2
+++ openacs-4/contrib/obsolete-packages/bboard/www/forum-oracle.xql	22 Aug 2001 21:01:35 -0000	1.3
@@ -60,7 +60,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
 	    and status = 'approved'