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.6 -r1.7
--- openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql	10 Sep 2003 12:42:01 -0000	1.6
+++ openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql	10 Sep 2003 14:26:06 -0000	1.7
@@ -6,8 +6,8 @@
     <fullquery name="auth::sync::job::get.select_job">
         <querytext>
             select job_id,
-                   job_start_time,
-                   job_end_time,
+                   to_char(job_start_time, 'YYYY-MM-DD HH24:MI:SS') as job_start_time,
+                   to_char(job_end_time, 'YYYY-MM-DD HH24:MI:SS') as job_end_time,
                    interactive_p,
                    snapshot_p,
                    authority_id,