Index: openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-display-procs-postgresql.xql,v
diff -u -r1.7.2.1 -r1.7.2.2
--- openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql	2 Mar 2003 22:41:11 -0000	1.7.2.1
+++ openacs-4/packages/calendar/tcl/calendar-display-procs-postgresql.xql	3 Mar 2003 17:42:27 -0000	1.7.2.2
@@ -109,8 +109,8 @@
 and      e.activity_id = a.activity_id
 and      start_date between
          to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
-and     cal_items.cal_item_id= e.event_id
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
+and      cal_items.cal_item_id= e.event_id
 and      e.event_id
 in       (
          select  cal_item_id
@@ -173,7 +173,7 @@
 and      e.activity_id = a.activity_id
 and      start_date between
          to_date(:current_date,:date_format) and
-         to_date(:current_date,:date_format) + (24 - 1/3600)/24
+         to_date(:current_date,:date_format) + cast('23 hours 59 minutes 59 seconds' as interval)
 and      e.event_id
 in       (
          select  cal_item_id