Index: openacs-4/packages/acs-admin/www/users/one.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one.xql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/acs-admin/www/users/one.xql	3 Sep 2003 19:48:24 -0000	1.13
+++ openacs-4/packages/acs-admin/www/users/one.xql	12 Sep 2003 13:25:50 -0000	1.14
@@ -3,12 +3,19 @@
 
 <fullquery name="user_info">      
       <querytext>
-      select first_names, last_name, username, email,
-          coalesce(screen_name,'&lt; none set up &gt;') as screen_name,
-          creation_date, creation_ip, last_visit, member_state,
-          email_verified_p, url
-      from cc_users
-      where user_id = :user_id
+      select first_names, 
+             last_name, 
+             username, 
+             email,
+             coalesce(screen_name,'&lt; none set up &gt;') as screen_name,
+             creation_date, 
+             creation_ip, 
+             to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, 
+             member_state,
+             email_verified_p, 
+             url
+      from   cc_users
+      where  user_id = :user_id
       </querytext>
 </fullquery>