Index: openacs-4/packages/press/www/admin/one-item-revision-add-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/press/www/admin/one-item-revision-add-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/press/www/admin/one-item-revision-add-postgresql.xql	31 Oct 2003 16:09:23 -0000	1.1
+++ openacs-4/packages/press/www/admin/one-item-revision-add-postgresql.xql	10 Nov 2003 19:11:51 -0000	1.2
@@ -8,7 +8,7 @@
 select pr.revision_id,
        publication_name,
        publication_link,
-       publication_date as item_publication_date,
+       publication_date::date as item_publication_date,
        publication_date_desc,
        article_title,
        article_link,
@@ -17,8 +17,8 @@
        html_p as article_abstract_html_p,
        template_id,
        template_name,
-       release_date as item_release_date,
-       archive_date as item_archive_date,
+       release_date::date as item_release_date,
+       archive_date::date as item_archive_date,
        status
   from press_item_revisions pr
  where pr.item_id = :item_id