Index: openacs-4/packages/forums/tcl/messages-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/Attic/messages-procs-oracle.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/forums/tcl/messages-procs-oracle.xql	2 Jul 2002 19:42:19 -0000	1.6
+++ openacs-4/packages/forums/tcl/messages-procs-oracle.xql	18 Nov 2002 18:01:07 -0000	1.7
@@ -14,7 +14,7 @@
                    (select fm2.subject
                     from forums_messages fm2 
                     where fm2.message_id = forums_message.root_message_id(forums_messages.message_id)) as root_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
             from forums_messages
             where forums_messages.message_id = :message_id
         </querytext>
@@ -31,7 +31,7 @@
                    (select fm2.subject
                     from forums_messages fm2 
                     where fm2.message_id = forums_message.root_message_id(forums_messages.message_id)) as root_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
             from forums_messages
             where forums_messages.message_id = :message_id
         </querytext>