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,