Index: openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql	17 May 2003 11:22:12 -0000	1.2
+++ openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql	28 Aug 2003 09:41:58 -0000	1.3
@@ -9,12 +9,12 @@
                r.timeout,
                r.summary_context_id,
                i.impl_name,
-               nvl2(r.lastbuild, date_part('epoch',r.lastbuild), 0) as lastbuild
+               nvl2(r.lastbuild, (r.lastbuild-to_date('1970-01-01'))*60*60*24, 0) as lastbuild
         from rss_gen_subscrs r,
              acs_sc_impls i
         where i.impl_id = r.impl_id
           and (r.lastbuild is null
-               or sysdate > r.lastbuild + r.timeout/(60*60*24)
+               or sysdate > r.lastbuild + r.timeout/(60*60*24))
     </querytext>
   </fullquery>