Index: openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql	16 Jul 2003 04:52:32 -0000	1.1
+++ openacs-4/contrib/packages/classified-ads/tcl/ads-procs.xql	18 Jul 2003 02:47:33 -0000	1.2
@@ -7,7 +7,8 @@
     
             select cm.keyword_id,
                    ci.item_id,
-                   cr.title
+                   cr.title,
+		   to_char(cr.publish_date, 'Mon DD, YYYY') as pretty_publish_date
             from cr_item_keyword_map cm,
                  cr_revisions cr,
                  cr_items ci
@@ -27,7 +28,8 @@
         <querytext>
     
             select ci.item_id,
-                   cr.title
+                   cr.title,
+		   to_char(cr.publish_date, 'Mon DD, YYYY') as pretty_publish_date
             from cr_revisions cr,
                  cr_items ci
             where ci.item_id not in (select item_id