Index: openacs-4/packages/forums/www/forum-view-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/forum-view-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/forums/www/forum-view-postgresql.xql	17 May 2003 10:43:31 -0000	1.9
+++ openacs-4/packages/forums/www/forum-view-postgresql.xql	20 Jun 2003 13:26:30 -0000	1.10
@@ -14,7 +14,7 @@
                     from forums_messages_approved fm1
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages,
-                   to_char(fm.last_child_post, 'Mon DD YYYY HH24:MI:SS') as last_child_post,
+                   to_char(fm.last_child_post, 'YYYY-MM-DD HH24:MI:SS') as last_child_post_ansi,
                    case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p                   
             from forums_messages_approved fm
             where fm.forum_id = :forum_id
@@ -35,7 +35,7 @@
                     from forums_messages fm1
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree_left(fm.tree_sortkey) and tree_right(fm.tree_sortkey)) as n_messages,
-                   to_char(fm.last_child_post, 'Mon DD YYYY HH24:MI:SS') as last_child_post,
+                   to_char(fm.last_child_post, 'YYYY-MM-DD HH24:MI:SS') as last_child_post_ansi,
                    case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p                   
             from forums_messages_approved fm
             where fm.forum_id = :forum_id
Index: openacs-4/packages/forums/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/index-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/forums/www/index-postgresql.xql	17 May 2003 10:43:31 -0000	1.7
+++ openacs-4/packages/forums/www/index-postgresql.xql	20 Jun 2003 13:26:30 -0000	1.8
@@ -10,7 +10,7 @@
                     from forums_messages
                     where forums_messages.forum_id = forums_forums_enabled.forum_id
                     and parent_id is null) as n_threads,
-                   to_char(last_post, 'Mon DD YYYY HH24:MI:SS') as last_post,
+                   to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
                    case when last_post > (now() - interval '1 day') then 't' else 'f' end as new_p
             from forums_forums_enabled
             where forums_forums_enabled.package_id = :package_id