Index: openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql	2 Oct 2003 09:45:15 -0000	1.13
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs-oracle.xql	28 Oct 2003 14:28:17 -0000	1.14
@@ -76,14 +76,18 @@
                  email_bouncing_p,
                  no_alerts_until,
                  last_visit,
+                 to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, 
                  second_to_last_visit,
+                 to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, 
                  n_sessions,
                  password_question,
                  password_answer,
                  password_changed_date,
                  member_state,
                  rel_id, 
-                 trunc(sysdate - password_changed_date) as password_age_days
+                 trunc(sysdate - password_changed_date) as password_age_days,
+                 creation_date,
+                 creation_ip
           from   cc_users 
           where  user_id = :user_id
 
@@ -108,14 +112,18 @@
                  email_bouncing_p,
                  no_alerts_until,
                  last_visit,
+                 to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, 
                  second_to_last_visit,
+                 to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, 
                  n_sessions,
                  password_question,
                  password_answer,
                  password_changed_date,
                  member_state,
                  rel_id, 
-                 trunc(sysdate - password_changed_date) as password_age_days
+                 trunc(sysdate - password_changed_date) as password_age_days,
+                 creation_date,
+                 creation_ip
           from   cc_users 
           where  authority_id = :authority_id
           and    upper(username) = upper(:username)