Index: openacs-4/packages/news/www/item-create-3-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/item-create-3-oracle.xql,v
diff -u -r1.2 -r1.2.18.1
--- openacs-4/packages/news/www/item-create-3-oracle.xql	24 Feb 2005 18:03:05 -0000	1.2
+++ openacs-4/packages/news/www/item-create-3-oracle.xql	15 Feb 2023 12:08:33 -0000	1.2.18.1
@@ -10,8 +10,8 @@
 :1 := news.new(
 title           => :publish_title,
 lead            => :publish_lead,
-publish_date    => :publish_date_ansi, 
-archive_date    => :archive_date_ansi,
+publish_date    => :publish_date,
+archive_date    => :archive_date,
 mime_type       => :mime_type,        
 package_id      => :package_id,       
 approval_user   => :approval_user,     
Index: openacs-4/packages/news/www/item-create-3-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/item-create-3-postgresql.xql,v
diff -u -r1.2 -r1.2.18.1
--- openacs-4/packages/news/www/item-create-3-postgresql.xql	24 Feb 2005 18:03:05 -0000	1.2
+++ openacs-4/packages/news/www/item-create-3-postgresql.xql	15 Feb 2023 12:08:33 -0000	1.2.18.1
@@ -11,13 +11,13 @@
     select news__new(
         null,               -- p_item_id
         null,               -- p_locale
-        :publish_date_ansi, -- p_publish_date
+        :publish_date,      -- p_publish_date
         :publish_body,      -- p_text
         null,               -- p_nls_language
         :publish_title,     -- p_title
         :mime_type,         -- p_mime_type
         :package_id,        -- p_package_id
-        :archive_date_ansi, -- p_archive_date
+        :archive_date,      -- p_archive_date
         :approval_user,     -- p_approval_user
         :approval_date,     -- p_approval_date
         :approval_ip,       -- p_approval_ip
Index: openacs-4/packages/news/www/item-create-3.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/item-create-3.tcl,v
diff -u -r1.22.2.4 -r1.22.2.5
--- openacs-4/packages/news/www/item-create-3.tcl	15 Mar 2022 15:56:30 -0000	1.22.2.4
+++ openacs-4/packages/news/www/item-create-3.tcl	15 Feb 2023 12:08:33 -0000	1.22.2.5
@@ -13,8 +13,8 @@
     publish_body:allhtml,notnull,trim
     publish_body.format:path,notnull,trim
     {publish_lead {}}
-    {publish_date_ansi:trim ""}
-    {archive_date_ansi:trim ""}
+    {publish_date:clock(%Y-%m-%d) {}}
+    {archive_date:clock(%Y-%m-%d) {}}
     permanent_p:boolean,notnull
 } -errors {
      imgfile_valid {Image file invalid}
@@ -50,7 +50,7 @@
 
 # Allow the user to "never expire" a news item.
 if {$permanent_p} {
-    set archive_date_ansi ""
+    set archive_date ""
 }
 
 # get creation_foo
Index: openacs-4/packages/news/www/admin/revision-add-3-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/revision-add-3-oracle.xql,v
diff -u -r1.2 -r1.2.18.1
--- openacs-4/packages/news/www/admin/revision-add-3-oracle.xql	24 Feb 2005 18:03:05 -0000	1.2
+++ openacs-4/packages/news/www/admin/revision-add-3-oracle.xql	15 Feb 2023 12:08:33 -0000	1.2.18.1
@@ -9,13 +9,13 @@
     begin
         :1 := news.revision_new(
             item_id       => :item_id,
-            publish_date  => :publish_date_ansi,
+            publish_date  => :publish_date,
             title         => :publish_title,   
             lead          => :publish_lead,
             description   => :revision_log,
             mime_type     => :mime_type,
             package_id    => [ad_conn package_id],
-            archive_date  => :archive_date_ansi,
+            archive_date  => :archive_date,
             approval_user => :approval_user,
             approval_date => :approval_date,
             approval_ip   => :approval_ip,
Index: openacs-4/packages/news/www/admin/revision-add-3-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/revision-add-3-postgresql.xql,v
diff -u -r1.2 -r1.2.18.1
--- openacs-4/packages/news/www/admin/revision-add-3-postgresql.xql	24 Feb 2005 18:03:05 -0000	1.2
+++ openacs-4/packages/news/www/admin/revision-add-3-postgresql.xql	15 Feb 2023 12:08:33 -0000	1.2.18.1
@@ -8,13 +8,13 @@
 
         select news__revision_new(
             :item_id,             -- p_item_id
-            :publish_date_ansi,   -- p_publish_date
+            :publish_date,        -- p_publish_date
 	    :publish_body,        -- p_text
             :publish_title,       -- p_title
             :revision_log,        -- p_description
             :mime_type,           -- p_mime_type
             [ad_conn package_id], -- p_package_id
-            :archive_date_ansi,   -- p_archive_date
+            :archive_date,        -- p_archive_date
             :approval_user,       -- p_approval_user
             :approval_date,       -- p_approval_date
             :approval_ip,         -- p_approval_ip
Index: openacs-4/packages/news/www/admin/revision-add-3.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/revision-add-3.tcl,v
diff -u -r1.16.2.1 -r1.16.2.2
--- openacs-4/packages/news/www/admin/revision-add-3.tcl	14 Feb 2019 16:15:01 -0000	1.16.2.1
+++ openacs-4/packages/news/www/admin/revision-add-3.tcl	15 Feb 2023 12:08:33 -0000	1.16.2.2
@@ -16,8 +16,8 @@
     publish_body:allhtml,notnull,trim
     publish_body.format:path,notnull
     revision_log:notnull
-    publish_date_ansi:notnull
-    archive_date_ansi:notnull
+    publish_date:clock(%Y-%m-%d),notnull
+    archive_date:clock(%Y-%m-%d),notnull
     permanent_p:boolean,notnull
 }