Index: openacs-4/packages/calendar/www/view-month-display-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/view-month-display-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/calendar/www/view-month-display-oracle.xql	25 Sep 2003 23:11:12 -0000	1.2
+++ openacs-4/packages/calendar/www/view-month-display-oracle.xql	9 Jan 2004 23:11:23 -0000	1.3
@@ -5,8 +5,8 @@
 	
 <fullquery name="select_monthly_items">
       <querytext>
-	select   to_char(start_date, :ansi_date_format) as ansi_start_date,
-                 to_char(end_date, :ansi_date_format) as ansi_end_date,
+	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,
 	         nvl(e.name, a.name) as name,
 	         nvl(e.description, a.description) as description,
                  nvl(e.status_summary, a.status_summary) as status_summary,
@@ -22,8 +22,8 @@
 	where    e.timespan_id = s.timespan_id
 	and      s.interval_id = t.interval_id
 	and      e.activity_id = a.activity_id
-        and      start_date between  to_date(:first_date_of_month_system, :ansi_date_format) 
-        and      to_date(:last_date_in_month_system, :ansi_date_format)
+        and      start_date between  to_date(:first_date_of_month_system, 'YYYY-MM-DD HH24:MI:SS') 
+        and      to_date(:last_date_in_month_system, 'YYYY-MM-DD HH24:MI:SS')
         and      cals.calendar_id = ci.on_which_calendar
 	and      e.event_id = ci.cal_item_id
 	$calendars_clause