Index: openacs-4/packages/news/lib/latest-news-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/lib/latest-news-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news/lib/latest-news-oracle.xql	27 Jan 2005 15:13:35 -0000	1.1
+++ openacs-4/packages/news/lib/latest-news-oracle.xql	15 Nov 2017 13:12:49 -0000	1.2
@@ -1,3 +1,4 @@
+<?xml version="1.0"?>
 <queryset>
 
 <rdbms><type>oracle</type><version></version></rdbms>
@@ -24,10 +25,4 @@
 </querytext>
 </fullquery>
 
-<partialquery name="max_age_filter">
-<querytext>
-   AND sysdate - to_timestamp(publish_date,'YYYY-MM-DD') < interval '$max_age' day
-</querytext>
-</partialquery>
-
-</queryset>
\ No newline at end of file
+</queryset>
Index: openacs-4/packages/news/lib/latest-news-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/lib/latest-news-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news/lib/latest-news-postgresql.xql	27 Jan 2005 15:13:35 -0000	1.1
+++ openacs-4/packages/news/lib/latest-news-postgresql.xql	15 Nov 2017 13:12:49 -0000	1.2
@@ -1,3 +1,4 @@
+<?xml version="1.0"?>
 <queryset>
 
 <rdbms><type>postgresql</type><version>7.3</version></rdbms>
@@ -18,8 +19,4 @@
 LIMIT $n
 </querytext></fullquery>
 
-<partialquery name="max_age_filter"><querytext>
-       AND age(publish_date) < interval :max_age_pg 
-</querytext></partialquery>
-
 </queryset>
Index: openacs-4/packages/news/lib/latest-news.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/lib/latest-news.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/news/lib/latest-news.tcl	7 Aug 2017 23:48:12 -0000	1.4
+++ openacs-4/packages/news/lib/latest-news.tcl	15 Nov 2017 13:12:49 -0000	1.5
@@ -51,7 +51,7 @@
 set max_age_filter {$max_age_filter}
 set n $n
 set package_id $package_id
-db_list_of_lists ls {} -bind { package_id $package_id max_age $max_age max_age_pg {$max_age days} }"
+db_list_of_lists ls {} -bind { package_id $package_id max_age $max_age }"
 
 multirow create news item_id title lead publish_date url date
 util_memoize_flush $script
@@ -66,8 +66,6 @@
     multirow append news $item_id $title $lead $publish_date $url $date
 }
 
-ad_return_template
-
 # Local variables:
 #    mode: tcl
 #    tcl-indent-level: 4
Index: openacs-4/packages/news/lib/latest-news.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/lib/latest-news.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/news/lib/latest-news.xql	15 Nov 2017 13:12:49 -0000	1.1
@@ -0,0 +1,10 @@
+<?xml version="1.0"?>
+<queryset>
+
+<partialquery name="max_age_filter">
+  <querytext>
+    AND CURRENT_DATE - DATE(publish_date) < $max_age
+  </querytext>
+</partialquery>
+
+</queryset>
\ No newline at end of file