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