Index: openacs-4/packages/calendar/www/view-week-display-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/www/view-week-display-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/calendar/www/view-week-display-postgresql.xql	25 Sep 2003 23:11:12 -0000	1.7
+++ openacs-4/packages/calendar/www/view-week-display-postgresql.xql	9 Jan 2004 23:11:23 -0000	1.8
@@ -17,13 +17,13 @@
 
 <fullquery name="select_week_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,
          coalesce(e.name, a.name) as name,
          coalesce(e.status_summary, a.status_summary) as status_summary,
          e.event_id as item_id,
-         (to_date(start_date,:ansi_date_format)  - to_date(:first_weekday_of_the_week_tz,
-         :ansi_date_format)) as day_of_week,
+         (to_date(start_date,'YYYY-MM-DD HH24:MI:SS')  - to_date(:first_weekday_of_the_week_tz,
+         'YYYY-MM-DD HH24:MI:SS')) as day_of_week,
          (select type from cal_item_types where item_type_id= cal_items.item_type_id) as item_type,
          cals.calendar_id,
 	 cals.calendar_name
@@ -37,8 +37,8 @@
 and      s.interval_id = t.interval_id
 and      e.activity_id = a.activity_id
 and      start_date between
-         to_date(:first_weekday_of_the_week_tz, :ansi_date_format) and
-         to_date(:last_weekday_of_the_week_tz, :ansi_date_format)
+         to_date(:first_weekday_of_the_week_tz, 'YYYY-MM-DD HH24:MI:SS') and
+         to_date(:last_weekday_of_the_week_tz, 'YYYY-MM-DD HH24:MI:SS')
 and      cals.calendar_id = ci.on_which_calendar
 and      e.event_id = ci.cal_item_id
 $calendars_clause