Index: openacs-4/contrib/packages/project-manager/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/index-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	4 Sep 2003 22:45:23 -0000	1.7
+++ openacs-4/contrib/packages/project-manager/www/index-postgresql.xql	18 Sep 2003 01:09:14 -0000	1.8
@@ -11,14 +11,14 @@
         p.object_type as content_type,
         p.title as project_name,
         p.project_code,
-        to_char(p.planned_start_date, 'Mon DD ''YY') as planned_start_date,
-        to_char(p.planned_end_date, 'Mon DD ''YY') as planned_end_date,
+        to_char(p.planned_start_date, 'MM/DD/YY') as planned_start_date,
+        to_char(p.planned_end_date, 'MM/DD/YY') as planned_end_date,
         p.ongoing_p,
         p.actual_hours_completed,
         p.estimated_hours_total,
-        to_char(p.estimated_finish_date, 'Mon DD ''YY') as estimated_finish_date,
-        to_char(p.earliest_finish_date, 'Mon DD ''YY') as earliest_finish_date,
-        to_char(p.latest_finish_date, 'Mon DD ''YY') as latest_finish_date
+        to_char(p.estimated_finish_date, 'MM/DD/YY') as estimated_finish_date,
+        to_char(p.earliest_finish_date, 'MM/DD/YY') as earliest_finish_date,
+        to_char(p.latest_finish_date, 'MM/DD/YY') as latest_finish_date
         FROM pm_projectsx p, cr_items i
         WHERE p.project_id = i.live_revision and
         p.parent_id = :root_folder