Index: openacs-4/packages/acs-admin/www/auth/authority-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/auth/Attic/authority-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-admin/www/auth/authority-oracle.xql	20 Oct 2003 15:05:26 -0000	1.1
+++ openacs-4/packages/acs-admin/www/auth/authority-oracle.xql	20 Oct 2003 15:13:26 -0000	1.2
@@ -18,7 +18,7 @@
                  and    e2.success_p = 'f') as num_problems,
                interactive_p,
                message,
-               (nvl(job_end_time, sysdate) - job_start_time) * 24*60*60 as run_time_seconds
+               round((nvl(job_end_time, sysdate) - job_start_time) * 24*60*60) as run_time_seconds
         from   auth_batch_jobs
         where  authority_id = :authority_id
 	
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.10 -r1.11
--- openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql	17 Oct 2003 11:09:58 -0000	1.10
+++ openacs-4/packages/acs-authentication/tcl/sync-procs-oracle.xql	20 Oct 2003 15:14:20 -0000	1.11
@@ -18,7 +18,7 @@
                    to_char(doc_end_time, 'YYYY-MM-DD HH24:MI:SS') as doc_end_time,
                    doc_status,
                    doc_message,
-                   (j.job_end_time - j.job_start_time) * 24*60*60 as run_time_seconds,
+                   round((j.job_end_time - j.job_start_time) * 24*60*60) as run_time_seconds,
                    (select count(e1.entry_id)
                     from   auth_batch_job_entries e1
                     where  e1.job_id = j.job_id) as num_actions,