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,