Index: openacs-4/packages/calendar/www/views-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/views-oracle.xql,v
diff -u -r1.4 -r1.4.2.1
--- openacs-4/packages/calendar/www/views-oracle.xql	19 Feb 2004 17:58:37 -0000	1.4
+++ openacs-4/packages/calendar/www/views-oracle.xql	3 May 2004 12:30:06 -0000	1.4.2.1
@@ -7,6 +7,9 @@
   <querytext>
     select to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_start_date,
          to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_end_date,
+         to_number(to_char(start_date,'HH24'),'90') as start_hour,
+         to_number(to_char(end_date,'HH24'),'90') as end_hour,
+         to_number(to_char(end_date,'MI'),'90') as end_minutes,
          nvl(e.name, a.name) as name,
          nvl(e.status_summary, a.status_summary) as status_summary,
          e.event_id as item_id,