Index: openacs-4/packages/calendar/www/cal-dayview-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/cal-dayview-postgresql.xql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/calendar/www/cal-dayview-postgresql.xql 23 Sep 2001 14:45:00 -0000 1.1 +++ openacs-4/packages/calendar/www/cal-dayview-postgresql.xql 3 Mar 2003 17:43:03 -0000 1.1.4.1 @@ -20,7 +20,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 @@ -49,7 +49,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