Index: openacs-4/packages/news/www/admin/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news/www/admin/index-oracle.xql	15 Oct 2001 13:41:03 -0000	1.1
+++ openacs-4/packages/news/www/admin/index-oracle.xql	18 Nov 2002 17:59:12 -0000	1.2
@@ -12,8 +12,8 @@
     content_revision.get_number(news_id) as revision_no,
     publish_title,
     html_p,
-    publish_date,
-    archive_date,
+    to_char(to_date(publish_date, 'MM-DD-yyyy'), 'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi,
+    to_char(to_date(archive_date, 'MM-DD-yyyy'), 'YYYY-MM-DD HH24:MI:SS') as archive_date_ansi,
     creation_user,
     item_creator,
     package_id,