Index: openacs-4/packages/forums/www/message-view-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/message-view-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/forums/www/message-view-postgresql.xql 30 Jul 2002 22:04:59 -0000 1.5 +++ openacs-4/packages/forums/www/message-view-postgresql.xql 18 Nov 2002 18:01:08 -0000 1.6 @@ -11,7 +11,7 @@ content, html_p, person__name(user_id) as user_name, - to_char(posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date, + to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi, tree_level(tree_sortkey) as tree_level, state, user_id @@ -30,7 +30,7 @@ content, html_p, person__name(user_id) as user_name, - to_char(posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date, + to_char(posting_date, 'YYYY-MM-DD HH24:MI:SS') as posting_date_ansi, tree_level(tree_sortkey) as tree_level, state, user_id