Index: openacs-4/packages/calendar/www/view-one-day-display-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/view-one-day-display-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/calendar/www/view-one-day-display-postgresql.xql	21 Jul 2003 19:21:36 -0000	1.2
+++ openacs-4/packages/calendar/www/view-one-day-display-postgresql.xql	22 Jul 2003 14:39:29 -0000	1.3
@@ -29,7 +29,8 @@
          to_date(:current_date,:date_format) and
          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      to_char(start_date, 'HH24') = '00'
+and      to_char(start_date, 'HH24:MI') = '00:00'
+and      to_char(end_date, 'HH24:MI') = '00:00'
 </querytext>
 </fullquery>
 
@@ -59,7 +60,8 @@
          to_date(:current_date,:date_format) and
          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      to_char(start_date, 'HH24') <> ''
+and      to_char(start_date, 'HH24:MI') <> '00:00'
+and      to_char(end_date, 'HH24:MI') <> '00:00'
 order by start_hour
 </querytext>
 </fullquery>