Index: openacs-4/packages/project-manager/www/task-one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/www/task-one-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/project-manager/www/task-one-postgresql.xql 5 Jun 2005 22:58:35 -0000 1.4 +++ openacs-4/packages/project-manager/www/task-one-postgresql.xql 30 Jul 2005 00:26:33 -0000 1.5 @@ -10,13 +10,13 @@ t.revision_id, t.description, t.mime_type, - to_char(t.earliest_start,'YYYY-MM-DD HH24:MI') as earliest_start, + to_char(t.earliest_start,'YYYY-MM-DD HH24:MI:SS') as 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.latest_start,'YYYY-MM-DD HH24:MI') as latest_start, + to_char(t.earliest_finish,'YYYY-MM-DD HH24:MI:SS') as earliest_finish, + to_char(t.latest_start,'YYYY-MM-DD HH24:MI:SS') as latest_start, to_char(t.latest_start,'J') as latest_start_j, - to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish, - to_char(t.end_date,'YYYY-MM-DD HH24:MI') as end_date, + to_char(t.latest_finish,'YYYY-MM-DD HH24:MI:SS') as latest_finish, + to_char(t.end_date,'YYYY-MM-DD HH24:MI:SS') as end_date, to_char(current_date,'J') as today_j, t.estimated_hours_work, t.estimated_hours_work_min,