Index: openacs-4/packages/news/sql/oracle/news-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/oracle/news-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/news/sql/oracle/news-create.sql	29 May 2002 23:04:16 -0000	1.4
+++ openacs-4/packages/news/sql/oracle/news-create.sql	12 Mar 2003 15:43:08 -0000	1.5
@@ -810,8 +810,8 @@
     ci.item_id as item_id,
     cn.news_id,
     cn.package_id,
-    to_char(cr.publish_date,'MM-DD-yyyy') as publish_date,
-    to_char(cn.archive_date,'MM-DD-yyyy') as archive_date,
+    cr.publish_date,
+    cn.archive_date,
     cr.title as publish_title,
     content.blob_to_string(cr.content) as publish_body,
     decode(cr.mime_type, 'text/html','t','f') as html_p,
@@ -877,8 +877,8 @@
     ci.live_revision,
     cr.title as publish_title,
     content.blob_to_string(cr.content) as publish_body,
-    cr.publish_date as publish_date,
-    cn.archive_date as archive_date,
+    cr.publish_date,
+    cn.archive_date,
     cr.description as log_entry,
     decode(cr.mime_type,'text/html','t','f') as html_p,
     cr.mime_type as mime_type,
Index: openacs-4/packages/news/sql/postgresql/news-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/news-create.sql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/news/sql/postgresql/news-create.sql	23 Feb 2003 18:21:19 -0000	1.10
+++ openacs-4/packages/news/sql/postgresql/news-create.sql	12 Mar 2003 15:43:39 -0000	1.11
@@ -749,7 +749,7 @@
     cr.content as publish_body,
     (case when cr.mime_type = 'text/html' then 't' else 'f' end) as html_p,
     to_char(cr.publish_date, 'Mon dd, yyyy') as pretty_publish_date,
-    cr.publish_date::date as publish_date,
+    cr.publish_date,
     ao.creation_user,
     ps.first_names || ' ' || ps.last_name as item_creator,
     cn.archive_date::date as archive_date    
@@ -779,8 +779,8 @@
     ci.item_id as item_id,
     cn.news_id,
     cn.package_id,
-    to_char(cr.publish_date,'MM-DD-yyyy') as publish_date,
-    to_char(cn.archive_date,'MM-DD-yyyy') as archive_date,
+    cr.publish_date,
+    cn.archive_date,
     cr.title as publish_title,
     cr.content as publish_body,
     (case when cr.mime_type = 'text/html' then 't' else 'f' end) as html_p,
@@ -849,8 +849,8 @@
     ci.live_revision,
     cr.title as publish_title,
     cr.content as publish_body,
-    cr.publish_date::date as publish_date,
-    cn.archive_date::date as archive_date,
+    cr.publish_date,
+    cn.archive_date,
     cr.description as log_entry,
     (case when cr.mime_type = 'text/html' then 't' else 'f' end) as html_p,
     cr.mime_type as mime_type,
@@ -913,8 +913,8 @@
     title as publish_title,
     cr.content as publish_body,
     (case when cr.mime_type = 'text/html' then 't' else 'f' end) as html_p,
-    cr.publish_date::date as publish_date,
-    cn.archive_date::date as archive_date,
+    cr.publish_date,
+    cn.archive_date,
     news__status(cr.revision_id) as status,
     ci.name as item_name,
     ps.person_id as creator_id,