Index: openacs-4/packages/calendar/tcl/cal-item-2-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/tcl/Attic/cal-item-2-procs-oracle.xql,v diff -u -N -r1.8 -r1.9 --- openacs-4/packages/calendar/tcl/cal-item-2-procs-oracle.xql 4 Dec 2002 09:44:35 -0000 1.8 +++ openacs-4/packages/calendar/tcl/cal-item-2-procs-oracle.xql 11 Aug 2003 12:14:15 -0000 1.9 @@ -21,10 +21,8 @@ select cal_items.cal_item_id, 0 as n_attachments, - start_date as start_date, - end_date as end_date, - 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_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as start_date_ansi, + to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as end_date_ansi, nvl(e.name, a.name) as name, nvl(e.description, a.description) as description, recurrence_id, @@ -52,16 +50,8 @@ select cal_items.cal_item_id, (select count(*) from attachments where object_id = cal_item_id) as n_attachments, - to_char(start_date,'HH:MIpm')as start_time, - to_char(start_date,'D') as day_of_week, - to_char(start_date,'Day') as pretty_day_of_week, - to_char(start_date,'DD') as day_of_month, - start_date as start_date, - to_char(start_date, 'MM/DD/YYYY') as pretty_short_start_date, - to_char(end_date, 'HH:MIpm') as end_time, - end_date as end_date, - 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_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as start_date_ansi, + to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as end_date_ansi, nvl(e.name, a.name) as name, nvl(e.description, a.description) as description, recurrence_id,