Index: openacs-4/packages/lars-blogger/www/blog-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/blog-postgresql.xql,v
diff -u -N -r1.7 -r1.7.2.1
--- openacs-4/packages/lars-blogger/www/blog-postgresql.xql	29 Sep 2003 08:05:42 -0000	1.7
+++ openacs-4/packages/lars-blogger/www/blog-postgresql.xql	5 Feb 2004 17:46:10 -0000	1.7.2.1
@@ -31,6 +31,8 @@
 		           p.last_name as poster_last_name,
 			   o.creation_user as user_id,
 		           to_char(posted_date , 'HH24:MI') as posted_time_pretty,
+		           to_char(e.entry_date , 'YYYY-MM-DD ')||to_char(e.posted_date , 'HH24:MI:SS') as entry_date_ansi,
+                           to_char(current_timestamp,'YYYY-MM-DD HH24:MI:SS') as sysdate_ansi,
 		           (select count(gc.comment_id) 
 		            from general_comments gc, cr_revisions cr 
 		            where gc.object_id = entry_id
@@ -62,6 +64,8 @@
                            p.last_name as poster_last_name,
                            o.creation_user as user_id,
                            to_char(posted_date , 'HH24:MI') as posted_time_pretty,
+		           to_char(e.entry_date , 'YYYY-MM-DD ')||to_char(e.posted_date , 'HH24:MI:SS') as entry_date_ansi,
+                           to_char(current_timestamp,'YYYY-MM-DD HH24:MI:SS') as sysdate_ansi,
                            (select count(gc.comment_id)
                             from general_comments gc, cr_revisions cr
                             where gc.object_id = entry_id