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 -N -r1.2 -r1.3 --- openacs-4/packages/news/www/admin/index-oracle.xql 18 Nov 2002 17:59:12 -0000 1.2 +++ openacs-4/packages/news/www/admin/index-oracle.xql 23 Sep 2003 23:00:17 -0000 1.3 @@ -12,8 +12,8 @@ content_revision.get_number(news_id) as revision_no, publish_title, html_p, - 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, + to_char(publish_date, 'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi, + to_char(archive_date, 'YYYY-MM-DD HH24:MI:SS') as archive_date_ansi, creation_user, item_creator, package_id,