Index: openacs-4/packages/news/www/admin/revision-add-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/Attic/revision-add-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/news/www/admin/revision-add-postgresql.xql	23 Aug 2003 22:03:49 -0000	1.2
+++ openacs-4/packages/news/www/admin/revision-add-postgresql.xql	23 Aug 2003 22:16:24 -0000	1.3
@@ -12,9 +12,9 @@
     revision_id,
     publish_title,
     html_p,
-    publish_date,
+    to_char(publish_date, 'YYYY-MM-DD') as publish_date,
     publish_body,
-    coalesce(archive_date, current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days') as archive_date,
+    to_char(coalesce(archive_date, current_timestamp + interval '[ad_parameter ActiveDays "news" 14] days'), 'YYYY-MM-DD') as archive_date,
     status
 from   
     news_item_full_active