Index: openacs-4/packages/news/www/admin/approve-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/approve-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news/www/admin/approve-postgresql.xql	15 Oct 2001 13:41:03 -0000	1.1
+++ openacs-4/packages/news/www/admin/approve-postgresql.xql	23 Aug 2003 22:03:49 -0000	1.2
@@ -5,7 +5,7 @@
 
 <fullquery name="week">      
       <querytext>
-      select current_timestamp + [ad_parameter ActiveDays "news" 14] 
+      select to_char(current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days', 'YYYY-DD-MM')
       </querytext>
 </fullquery>
 
Index: openacs-4/packages/news/www/admin/revision-add-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/Attic/revision-add-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news/www/admin/revision-add-postgresql.xql	15 Oct 2001 13:41:03 -0000	1.1
+++ openacs-4/packages/news/www/admin/revision-add-postgresql.xql	23 Aug 2003 22:03:49 -0000	1.2
@@ -14,7 +14,7 @@
     html_p,
     publish_date,
     publish_body,
-    coalesce(archive_date, current_timestamp+[ad_parameter ActiveDays "news" 14]) as archive_date,
+    coalesce(archive_date, current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days') as archive_date,
     status
 from   
     news_item_full_active