Index: openacs-4/packages/project-manager/lib/projects-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/projects-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/project-manager/lib/projects-postgresql.xql	21 Jun 2005 11:24:54 -0000	1.3
+++ openacs-4/packages/project-manager/lib/projects-postgresql.xql	30 Jul 2005 00:26:33 -0000	1.4
@@ -12,18 +12,18 @@
         p.object_type as content_type,
         p.title as project_name,
         p.project_code,
-        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,
+        to_char(p.planned_start_date, 'YYYY-MM-DD HH24:MI:SS') as planned_start_date,
+        to_char(p.planned_end_date, 'YYYY-MM-DD HH24:MI:SS') as planned_end_date,
         p.ongoing_p,
         c.category_id,
         c.category_name,
         p.earliest_finish_date - current_date as days_to_earliest_finish,
         p.latest_finish_date - current_date as days_to_latest_finish,
         p.actual_hours_completed,
         p.estimated_hours_total,
-        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,
+        to_char(p.estimated_finish_date, 'YYYY-MM-DD HH24:MI:SS') as estimated_finish_date,
+        to_char(p.earliest_finish_date, 'YYYY-MM-DD HH24:MI:SS') as earliest_finish_date,
+        to_char(p.latest_finish_date, 'YYYY-MM-DD HH24:MI:SS') as latest_finish_date,
         case when o.name is null then '--no customer--' else o.name
                 end as customer_name,
         o.organization_id as customer_id