Index: openacs-4/packages/acs-admin/www/users/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-admin/www/users/one-postgresql.xql	29 Apr 2001 01:28:46 -0000	1.2
+++ openacs-4/packages/acs-admin/www/users/one-postgresql.xql	30 Jan 2004 09:54:03 -0000	1.3
@@ -5,12 +5,12 @@
 
 <fullquery name="user_contributions">      
       <querytext>
-      select at.pretty_name, at.pretty_plural, a.creation_date,
+      select at.pretty_name, at.pretty_plural, to_char(a.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date,
           acs_object__name(a.object_id) as object_name
       from acs_objects a, acs_object_types at
       where a.object_type = at.object_type
           and a.creation_user = :user_id
-      order by object_name, creation_date
+      order by pretty_name, creation_date desc, object_name
       </querytext>
 </fullquery>