Index: openacs-4/packages/calendar/www/view-month-display-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/Attic/view-month-display-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/calendar/www/view-month-display-postgresql.xql	26 Jul 2003 21:08:16 -0000	1.4
+++ openacs-4/packages/calendar/www/view-month-display-postgresql.xql	14 Aug 2003 15:44:08 -0000	1.5
@@ -5,10 +5,8 @@
 	
 <fullquery name="select_monthly_items">
       <querytext>
-	select   to_char(start_date, 'J') as julian_start_date,
-                 to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as ansi_start_date,
-                 to_char(start_date, 'HH24:MI') as ansi_start_time,
-                 to_char(end_date, 'HH24:MI') as ansi_end_time,
+	select   to_char(start_date, :ansi_date_format) as ansi_start_date,
+                 to_char(end_date, :ansi_date_format) as ansi_end_date,
 	         coalesce(e.name, a.name) as name,
 	         coalesce(e.description, a.description) as description,
                  coalesce(e.status_summary, a.status_summary) as status_summary,
@@ -24,18 +22,14 @@
 	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_julian_date_of_month,'J') 
-        and      to_date(:last_julian_date_in_month,'J')
+        and      start_date between  to_timestamp(:first_date_of_month_system, :ansi_date_format) 
+        and      to_timestamp(:last_date_in_month_system, :ansi_date_format)
         and      cals.package_id= :package_id
         and      (cals.private_p='f' or (cals.private_p='t' and cals.owner_id= :user_id))
         and      cals.calendar_id = ci.on_which_calendar
 	and      e.event_id = ci.cal_item_id
         order by ansi_start_date
-
 </querytext>
 </fullquery>
-
-
  
 </queryset>
-