Index: openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql,v
diff -u -r1.16 -r1.17
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	27 Jun 2007 18:54:48 -0000	1.16
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	15 Jan 2008 18:29:23 -0000	1.17
@@ -19,7 +19,7 @@
             where nnr.notification_id = notification_user_map.notification_id(+)
               and nnr.user_id = notification_user_map.user_id(+)
 	      and notification_user_map.sent_date is null
-	      and notifications.notif_date < sysdate()
+	      and notifications.notif_date < sysdate
         </querytext>
     </fullquery>
 
@@ -46,7 +46,7 @@
             where nnr.notification_id = notification_user_map.notification_id(+)
               and nnr.user_id = notification_user_map.user_id(+)
               and notification_user_map.sent_date is null
-              and nnr.notif_date < sysdate()
+              and nnr.notif_date < sysdate
               and acs_objects.object_id = nnr.request_id
               and acs_objects.creation_date <= nnr.notif_date
             order by nnr.user_id, nnr.type_id, nnr.notif_date