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.10 -r1.11
--- openacs-4/packages/workflow/tcl/case-procs-oracle.xql	15 Mar 2004 14:04:06 -0000	1.10
+++ openacs-4/packages/workflow/tcl/case-procs-oracle.xql	1 Dec 2005 14:11:44 -0000	1.11
@@ -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.9 -r1.10
--- openacs-4/packages/workflow/tcl/case-procs-postgresql.xql	15 Mar 2004 14:04:06 -0000	1.9
+++ openacs-4/packages/workflow/tcl/case-procs-postgresql.xql	1 Dec 2005 14:11:44 -0000	1.10
@@ -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,