Index: openacs-4/packages/news-portlet/www/news-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-portlet/www/Attic/news-portlet-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/news-portlet/www/news-portlet-oracle.xql	20 Jun 2002 22:49:57 -0000	1.5
+++ openacs-4/packages/news-portlet/www/news-portlet-oracle.xql	18 Nov 2002 17:59:27 -0000	1.6
@@ -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 < sysdate
             and (news_items_approved.archive_date >= sysdate or news_items_approved.archive_date is null)