Index: openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql,v
diff -u -N -r1.8 -r1.8.2.1
--- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	24 Feb 2005 13:33:03 -0000	1.8
+++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql	1 Dec 2005 13:25:33 -0000	1.8.2.1
@@ -11,14 +11,14 @@
              b.summary,
              b.component_id,
              b.creation_date,
-             to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
+             to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
              b.resolution,
              b.user_agent,
              b.found_in_version,
              b.found_in_version,
              b.fix_for_version,
              b.fixed_in_version,
-             to_char(sysdate, 'fmMM/DDfm/YYYY') as now_pretty
+             to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as now_pretty
       from   bt_bugs b
       where  b.bug_id = :bug_id
     </querytext>
@@ -120,7 +120,7 @@
          b.comment_format,
          b.component_id,
          b.creation_date,
-         to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
+         to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
          b.creation_user as submitter_user_id,
          submitter.first_names as submitter_first_names,
          submitter.last_name as submitter_last_name,
@@ -170,7 +170,7 @@
          b.comment_format,
          b.component_id,
          b.creation_date,
-         to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
+         to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
          b.creation_user as submitter_user_id,
          submitter.first_names as submitter_first_names,
          submitter.last_name as submitter_last_name,