Index: openacs-4/packages/workflow/tcl/case-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/case-procs-oracle.xql,v diff -u -r1.9 -r1.9.2.1 --- openacs-4/packages/workflow/tcl/case-procs-oracle.xql 5 Feb 2004 10:37:33 -0000 1.9 +++ openacs-4/packages/workflow/tcl/case-procs-oracle.xql 1 Dec 2005 14:12:11 -0000 1.9.2.1 @@ -65,7 +65,7 @@ iou.last_name as user_last_name, iou.email as user_email, io.creation_date, - to_char(io.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(io.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, blob_to_string(r.content) as comment_string, -- needs il8-ing... r.mime_type as comment_mime_type, d.key, Index: openacs-4/packages/workflow/tcl/case-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/case-procs-postgresql.xql,v diff -u -r1.8.2.1 -r1.8.2.2 --- openacs-4/packages/workflow/tcl/case-procs-postgresql.xql 16 Mar 2004 16:17:45 -0000 1.8.2.1 +++ openacs-4/packages/workflow/tcl/case-procs-postgresql.xql 1 Dec 2005 14:12:11 -0000 1.8.2.2 @@ -63,7 +63,7 @@ iou.last_name as user_last_name, iou.email as user_email, io.creation_date, - to_char(io.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(io.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, r.content as comment_string, r.mime_type as comment_mime_type, d.key,