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 -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