Index: openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql	17 Jul 2002 20:22:30 -0000	1.1
+++ openacs-4/packages/news-portlet/www/news-portlet-postgresql.xql	18 Nov 2002 17:59:27 -0000	1.2
@@ -12,7 +12,7 @@
                     where site_nodes.object_id = news_items_approved.package_id) as url,
                    news_items_approved.item_id,
                    news_items_approved.publish_title,
-                   news_items_approved.publish_date
+                   to_char(news_items_approved.publish_date, 'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi
             from news_items_approved
             where news_items_approved.publish_date < current_timestamp
             and (news_items_approved.archive_date >= current_timestamp or news_items_approved.archive_date is null)