Index: openacs-4/packages/bug-tracker/www/map-patch-to-bugs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/map-patch-to-bugs-oracle.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/bug-tracker/www/map-patch-to-bugs-oracle.xql	5 Mar 2003 17:41:04 -0000	1.1
+++ openacs-4/packages/bug-tracker/www/map-patch-to-bugs-oracle.xql	1 Dec 2005 13:06:10 -0000	1.2
@@ -11,7 +11,7 @@
               from (
                   select bt_bugs.bug_number,
                          bt_bugs.summary,
-                         to_char(acs_objects.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty                
+                         to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty                
                   from   bt_bugs, acs_objects, workflow_cases cas, workflow_case_fsm cfsm
                   where  bt_bugs.bug_id = acs_objects.object_id
                   and    $sql_where_clause
Index: openacs-4/packages/bug-tracker/www/map-patch-to-bugs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/map-patch-to-bugs-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/bug-tracker/www/map-patch-to-bugs-postgresql.xql	5 Mar 2003 17:41:04 -0000	1.1
+++ openacs-4/packages/bug-tracker/www/map-patch-to-bugs-postgresql.xql	1 Dec 2005 13:06:10 -0000	1.2
@@ -7,7 +7,7 @@
       <querytext>
 select bt_bugs.bug_number,
                 bt_bugs.summary,
-                to_char(acs_objects.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty                
+                to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty                
                 from bt_bugs, acs_objects, workflow_cases cas, workflow_case_fsm cfsm
                 where bt_bugs.bug_id = acs_objects.object_id
                  and  $sql_where_clause
Index: openacs-4/packages/bug-tracker/www/patch-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/patch-list.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/bug-tracker/www/patch-list.xql	24 Feb 2005 13:33:04 -0000	1.3
+++ openacs-4/packages/bug-tracker/www/patch-list.xql	1 Dec 2005 13:06:10 -0000	1.4
@@ -48,7 +48,7 @@
     select bt_patches.patch_number,
            bt_patches.summary,
            bt_patches.status,
-           to_char(acs_objects.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
+           to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
            bt_components.component_name,
            (select atv.version_name 
             from   bt_versions atv 
Index: openacs-4/packages/bug-tracker/www/patch-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/patch-oracle.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/bug-tracker/www/patch-oracle.xql	24 Feb 2005 13:33:04 -0000	1.2
+++ openacs-4/packages/bug-tracker/www/patch-oracle.xql	1 Dec 2005 13:06:10 -0000	1.3
@@ -21,8 +21,8 @@
             submitter.last_name as submitter_last_name,
             submitter.email as submitter_email,
             acs_objects.creation_date,
-            to_char(acs_objects.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
-            to_char(sysdate, 'fmMM/DDfm/YYYY') as now_pretty
+            to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
+            to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as now_pretty
      from bt_patches,
           acs_objects,
 	  acs_users_all submitter,
Index: openacs-4/packages/bug-tracker/www/patch-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/Attic/patch-postgresql.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/bug-tracker/www/patch-postgresql.xql	24 Feb 2005 13:33:04 -0000	1.2
+++ openacs-4/packages/bug-tracker/www/patch-postgresql.xql	1 Dec 2005 13:06:10 -0000	1.3
@@ -21,8 +21,8 @@
             submitter.last_name as submitter_last_name,
             submitter.email as submitter_email,
             acs_objects.creation_date,
-            to_char(acs_objects.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty,
-            to_char(now(), 'fmMM/DDfm/YYYY') as now_pretty
+            to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
+            to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as now_pretty
      from bt_patches,
           acs_objects,
           acs_users_all submitter,
Index: openacs-4/packages/bug-tracker/www/patch.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/patch.xql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/bug-tracker/www/patch.xql	18 Sep 2005 19:16:22 -0000	1.3
+++ openacs-4/packages/bug-tracker/www/patch.xql	1 Dec 2005 13:06:10 -0000	1.4
@@ -24,7 +24,7 @@
                actor.last_name as actor_last_name,
                actor.email as actor_email,
                bt_patch_actions.action_date,
-               to_char(bt_patch_actions.action_date, 'fmMM/DDfm/YYYY') as action_date_pretty,
+               to_char(bt_patch_actions.action_date, 'YYYY-MM-DD HH24:MI:SS') as action_date_pretty,
                bt_patch_actions.comment_text,
                bt_patch_actions.comment_format
         from   bt_patch_actions,