Index: openacs-4/packages/calendar/tcl/calendar-display-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/calendar-display-procs-oracle.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/calendar/tcl/calendar-display-procs-oracle.xql	14 May 2002 05:06:29 -0000	1.8
+++ openacs-4/packages/calendar/tcl/calendar-display-procs-oracle.xql	15 May 2002 20:32:19 -0000	1.9
@@ -7,6 +7,8 @@
       <querytext>
       
 	select   to_char(start_date, 'j') as start_date,
+                 to_char(start_date, 'HH:MIpm') as start_time,
+                 to_char(end_date, 'HH:MIpm') as end_time,
 	         nvl(e.name, a.name) as name,
 	         nvl(e.description, a.description) as description,
                  nvl(e.status_summary, a.status_summary) as status_summary,
@@ -24,6 +26,7 @@
 	         from    cal_items
 	         where   on_which_calendar = :calendar_id
          )
+         order by start_date,end_date
 	
       </querytext>
 </fullquery>