Index: openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql	16 Sep 2003 13:07:42 -0000	1.8
+++ openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql	16 Oct 2003 13:40:15 -0000	1.9
@@ -11,10 +11,11 @@
                    interactive_p,
                    snapshot_p,
                    authority_id,
+                   (select aa.pretty_name from auth_authorities aa where aa.authority_id = j.authority_id) as authority_pretty_name,
                    message,
                    creation_user,
-                   doc_start_time,
-                   doc_end_time,
+                   to_char(doc_start_time, 'YYYY-MM-DD HH24:MI:SS') as doc_start_time,
+                   to_char(doc_end_time, 'YYYY-MM-DD HH24:MI:SS') as doc_end_time,
                    doc_status,
                    doc_message,
                    document,