Index: openacs-4/contrib/packages/project-manager/www/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/one-postgresql.xql,v
diff -u -r1.17 -r1.18
--- openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	17 Sep 2003 22:20:59 -0000	1.17
+++ openacs-4/contrib/packages/project-manager/www/one-postgresql.xql	18 Sep 2003 01:09:14 -0000	1.18
@@ -33,13 +33,13 @@
 	p.project_code,
 	p.goal,
 	p.description,
-	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,
         i.live_revision,
-        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,
         p.actual_hours_completed,
         p.estimated_hours_total,
         p.parent_id
@@ -61,13 +61,13 @@
 	p.project_code,
 	p.goal,
 	p.description,
-	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,
         i.live_revision,
-        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,
         p.estimated_hours_total
 	FROM
 	pm_projectsx p, cr_items i
@@ -84,12 +84,12 @@
 	SELECT
         t.item_id as task_id,
         t.title,
-	to_char(t.end_date,'Mon DD ''YY') as end_date,
-	to_char(t.earliest_start,'Mon DD ''YY') as earliest_start,
-	to_char(t.earliest_finish,'Mon DD ''YY') as earliest_finish,
-	to_char(t.latest_start,'Mon DD ''YY') as latest_start,
-	to_char(t.latest_finish,'Mon DD ''YY') as latest_finish,
-        to_char(t.latest_start-t.earliest_start,'DD') || ' days' as slack_time,
+	to_char(t.end_date,'MM/DD/YY') as end_date,
+	to_char(t.earliest_start,'MM/DD/YY') as earliest_start,
+	to_char(t.earliest_finish,'MM/DD/YY') as earliest_finish,
+	to_char(t.latest_start,'MM/DD/YY') as latest_start,
+	to_char(t.latest_finish,'MM/DD/YY') as latest_finish,
+        to_char(t.latest_start-t.earliest_start,'FMDD') || ' days' as slack_time,
         u.first_names,
         u.last_name,
         t.percent_complete,
@@ -124,8 +124,8 @@
 	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