Index: openacs-4/packages/forums/tcl/messages-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/messages-procs.tcl,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/forums/tcl/messages-procs.tcl	30 Nov 2002 17:35:17 -0000	1.14
+++ openacs-4/packages/forums/tcl/messages-procs.tcl	4 Dec 2002 09:46:29 -0000	1.15
@@ -164,7 +164,8 @@
         }
 
         db_1row $query {} -column_array row
-        
+
+        # Convert to user's date/time format
         set row(posting_date_pretty) [lc_time_fmt $row(posting_date_ansi) "%x %X"]
     }
 
Index: openacs-4/packages/forums/www/forum-view.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/forum-view.tcl,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/forums/www/forum-view.tcl	30 Nov 2002 17:35:39 -0000	1.11
+++ openacs-4/packages/forums/www/forum-view.tcl	4 Dec 2002 09:46:40 -0000	1.12
@@ -67,7 +67,7 @@
 }
 
 db_multirow -extend { last_post_pretty } messages $query {} {
-    set last_post_pretty [lc_time_fmt $last_post_ansi "%x %X"]
+    set last_child_post_pretty [lc_time_fmt $last_child_post_ansi "%x %X"]
 }
 
 set notification_chunk [notification::display::request_widget \
Index: openacs-4/packages/forums/www/message-view.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/message-view.tcl,v
diff -u -r1.14 -r1.15
--- openacs-4/packages/forums/www/message-view.tcl	30 Nov 2002 17:35:39 -0000	1.14
+++ openacs-4/packages/forums/www/message-view.tcl	4 Dec 2002 09:46:40 -0000	1.15
@@ -89,7 +89,7 @@
     set order_by "tree_sortkey"
 }
 
-db_multirow -extend { posting_date_pretty } responses $query {} { 
+db_multirow -extend { posting_date_pretty } responses $query {} {
     set subject [ad_quotehtml $subject]
     set posting_date_pretty [lc_time_fmt $posting_date_ansi "%x %X"]
 }
Index: openacs-4/packages/forums/www/search-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/search-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums/www/search-oracle.xql	2 Jul 2002 06:11:59 -0000	1.2
+++ openacs-4/packages/forums/www/search-oracle.xql	4 Dec 2002 09:46:40 -0000	1.3
@@ -7,7 +7,7 @@
         <querytext>
             select forums_messages.*,
                    person.name(forums_messages.user_id) as user_name,
-                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
+                   to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
                    score(1) as the_score
             from forums_messages,
                  forums_forums
@@ -24,7 +24,7 @@
         <querytext>
             select forums_messages.*,
                    person.name(forums_messages.user_id) as user_name,
-                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
+                   to_char(forums_messages.posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
                    score(1) as the_score
             from forums_messages,
                  forums_forums
Index: openacs-4/packages/forums/www/search-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/search-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums/www/search-postgresql.xql	13 Aug 2002 17:01:36 -0000	1.2
+++ openacs-4/packages/forums/www/search-postgresql.xql	4 Dec 2002 09:46:40 -0000	1.3
@@ -7,7 +7,7 @@
         <querytext>
             select forums_messages.*,
                    person__name(forums_messages.user_id) as user_name,
-                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
+                   to_char(forums_messages.posting_date_ansi, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
                    100 as the_score
             from forums_messages,
                  forums_forums
@@ -27,7 +27,7 @@
         <querytext>
             select forums_messages.*,
                    person__name(forums_messages.user_id) as user_name,
-                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
+                   to_char(forums_messages.posting_date_ansi, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi,
                    100 as the_score
             from forums_messages,
                  forums_forums
Index: openacs-4/packages/forums/www/search.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/search.tcl,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/forums/www/search.tcl	25 Oct 2002 13:00:02 -0000	1.7
+++ openacs-4/packages/forums/www/search.tcl	4 Dec 2002 09:46:40 -0000	1.8
@@ -37,7 +37,9 @@
         set query search_one_forum
     }
 
-    db_multirow messages $query {}
+    db_multirow messages $query {} {
+        set posting_date_pretty [lc_time_fmt $posting_date_ansi "%x %X"]
+    }
 
 } else {
     set messages:rowcount 0