Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v diff -u -r1.24 -r1.25 --- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 3 Jun 2004 21:32:13 -0000 1.24 +++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql 10 Jun 2004 20:38:29 -0000 1.25 @@ -10,13 +10,12 @@ t.revision_id, t.description, t.mime_type, - 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_start,'YYYY-MM-DD HH24:MI') as earliest_start, to_char(t.earliest_start,'J') as earliest_start_j, - 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.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.latest_start,'J') as latest_start_j, - to_char(t.latest_finish,'Mon DD ''YY') as latest_finish, + to_char(t.latest_finish,'YYYY-MM-DD HH24:MI') as latest_finish, to_char(current_date,'J') as today_j, t.estimated_hours_work, t.estimated_hours_work_min,