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, Index: openacs-4/contrib/packages/project-manager/www/task-one.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one.tcl,v diff -u -r1.32 -r1.33 --- openacs-4/contrib/packages/project-manager/www/task-one.tcl 10 Jun 2004 20:23:12 -0000 1.32 +++ openacs-4/contrib/packages/project-manager/www/task-one.tcl 10 Jun 2004 20:38:29 -0000 1.33 @@ -106,6 +106,12 @@ db_1row task_query { } -column_array task_info +# format the dates according to the local settings +set task_info(earliest_start) [lc_time_fmt $task_info(earliest_start) "%x"] +set task_info(earliest_finish) [lc_time_fmt $task_info(earliest_finish) "%x"] +set task_info(latest_start) [lc_time_fmt $task_info(latest_start) "%x"] +set task_info(latest_finish) [lc_time_fmt $task_info(latest_finish) "%x"] + # we do this for the hours include portion set project_item_id $task_info(project_item_id)