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 @@ 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,