Index: openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql,v
diff -u -r1.6.4.3 -r1.6.4.4
--- openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql	25 Dec 2004 21:46:49 -0000	1.6.4.3
+++ openacs-4/packages/forums/sql/oracle/forums-messages-package-create.sql	4 Jan 2005 19:31:49 -0000	1.6.4.4
@@ -146,13 +146,13 @@
             update forums_messages
             set approved_reply_count = approved_reply_count + 1,
               reply_count = reply_count + 1,
-              last_child_post = current_timestamp
+              last_child_post = sysdate
             where forum_id = forums_message.new.forum_id
               and tree_sortkey = tree.ancestor_key(v_sortkey, 1);
           else
             update forums_messages
             set reply_count = reply_count + 1,
-              last_child_post = current_timestamp
+              last_child_post = sysdate
             where forum_id = forums_message.new.forum_id
               and tree_sortkey = tree.ancestor_key(v_sortkey, 1);
           end if;
Index: openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql	25 Dec 2004 21:46:50 -0000	1.1.2.2
+++ openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.0.6-1.0.7d.sql	4 Jan 2005 19:31:49 -0000	1.1.2.3
@@ -182,13 +182,13 @@
             update forums_messages
             set approved_reply_count = approved_reply_count + 1,
               reply_count = reply_count + 1,
-              last_child_post = current_timestamp
+              last_child_post = sysdate
             where forum_id = forums_message.new.forum_id
               and tree_sortkey = tree.ancestor_key(v_sortkey, 1);
           else
             update forums_messages
             set reply_count = reply_count + 1,
-              last_child_post = current_timestamp
+              last_child_post = sysdate
             where forum_id = forums_message.new.forum_id
               and tree_sortkey = tree.ancestor_key(v_sortkey, 1);
           end if;