Index: openacs-4/packages/dotlrn-forums/www/user-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/www/user-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn-forums/www/user-oracle.xql	9 Jul 2002 19:48:46 -0000	1.1
+++ openacs-4/packages/dotlrn-forums/www/user-oracle.xql	13 Aug 2003 13:33:11 -0000	1.2
@@ -7,7 +7,7 @@
         <querytext>
             select forums_messages.message_id,
                    forums_messages.subject,
-                   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,
                    forums_forums.forum_id,
                    forums_forums.package_id,
                    forums_forums.name as forum_name,
@@ -26,7 +26,7 @@
         <querytext>
             select forums_messages.message_id,
                    forums_messages.subject,
-                   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,
                    forums_forums.forum_id,
                    forums_forums.package_id,
                    forums_forums.name as forum_name,
Index: openacs-4/packages/dotlrn-forums/www/user-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/www/user-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn-forums/www/user-postgresql.xql	21 Jul 2002 20:13:12 -0000	1.1
+++ openacs-4/packages/dotlrn-forums/www/user-postgresql.xql	13 Aug 2003 13:33:11 -0000	1.2
@@ -7,7 +7,7 @@
         <querytext>
             select forums_messages.message_id,
                    forums_messages.subject,
-                   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,
                    forums_forums.forum_id,
                    forums_forums.package_id,
                    forums_forums.name as forum_name,
@@ -26,7 +26,7 @@
         <querytext>
             select forums_messages.message_id,
                    forums_messages.subject,
-                   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,
                    forums_forums.forum_id,
                    forums_forums.package_id,
                    forums_forums.name as forum_name,
Index: openacs-4/packages/dotlrn-forums/www/user.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/www/user.adp,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn-forums/www/user.adp	11 Nov 2002 10:39:48 -0000	1.2
+++ openacs-4/packages/dotlrn-forums/www/user.adp	13 Aug 2003 13:33:11 -0000	1.3
@@ -45,7 +45,7 @@
 
       <td><a href="@messages.url@forum-view?forum_id=@messages.forum_id@">@messages.forum_name@</a></td>
       <td><a href="@messages.url@message-view?message_id=@messages.message_id@">@messages.subject@</a></td>
-      <td align="center">@messages.posting_date@</td>
+      <td align="center">@messages.posting_date_pretty@</td>
 
     </tr>
 
@@ -88,7 +88,7 @@
   </else>
 
       <td><a href="@messages.url@message-view?message_id=@messages.message_id@">@messages.subject@</a></td>
-      <td align="center">@messages.posting_date@</td>
+      <td align="center">@messages.posting_date_pretty@</td>
 
     </tr>