Index: openacs-4/packages/project-manager/lib/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/tasks-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/project-manager/lib/tasks-postgresql.xql	28 Jul 2005 07:54:14 -0000	1.3
+++ openacs-4/packages/project-manager/lib/tasks-postgresql.xql	30 Jul 2005 00:26:33 -0000	1.4
@@ -8,19 +8,19 @@
         t.item_id as task_item_id,
         t.parent_id as project_item_id,
         t.title,
-	to_char(t.end_date,'YYYY-MM-DD HH24:MI') as end_date,
-	to_char(t.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start,
+	to_char(t.end_date,'YYYY-MM-DD HH24:MI:SS') as end_date,
+	to_char(t.earliest_start,'YYYY-MM-DD HH24:MI:SS') as earliest_start,
 	t.earliest_start - current_date as days_to_earliest_start,
 	to_char(t.earliest_start,'J') as earliest_start_j,
-	to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI') as earliest_finish,
+	to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI:SS') as earliest_finish,
 	t.earliest_finish - current_date as days_to_earliest_finish,
-	to_char(t.latest_start,'YYYY-MM-DD HH24:MI') as latest_start,
+	to_char(t.latest_start,'YYYY-MM-DD HH24:MI:SS') as latest_start,
 	t.latest_start - current_date as days_to_latest_start,
 	to_char(t.latest_start,'J') as latest_start_j,
 	to_char(current_date,'J') as today_j,
-	to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish,
+	to_char(t.latest_finish,'YYYY-MM-DD HH24:MI:SS') as latest_finish,
 	t.latest_finish - current_date as days_to_latest_finish,
-	to_char(t.end_date,'YYYY-MM-DD HH24:MI') as end_date,
+	to_char(t.end_date,'YYYY-MM-DD HH24:MI:SS') as end_date,
 	t.end_date - current_date as days_to_end_date,
         u.person_id,
         u.first_names,