Index: openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql	10 Sep 2003 12:42:01 -0000	1.5
+++ openacs-4/packages/acs-authentication/tcl/sync-procs-postgresql.xql	10 Sep 2003 14:26:06 -0000	1.6
@@ -6,16 +6,16 @@
     <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,
                    (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,