Index: openacs-4/packages/lars-blogger/tcl/entry-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/entry-procs-oracle.xql,v diff -u -r1.4.2.1 -r1.4.2.2 --- openacs-4/packages/lars-blogger/tcl/entry-procs-oracle.xql 24 Nov 2003 13:32:15 -0000 1.4.2.1 +++ openacs-4/packages/lars-blogger/tcl/entry-procs-oracle.xql 5 Feb 2004 17:46:10 -0000 1.4.2.2 @@ -37,6 +37,8 @@ p.first_names as poster_first_names, p.last_name as poster_last_name, to_char(b.posted_date , 'HH24:MI') as posted_time_pretty, + to_char(b.entry_date , 'YYYY-MM-DD ')||to_char(b.posted_date , 'HH24:MI:SS') as entry_date_ansi, + to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') as sysdate_ansi, b.package_id, (select count(gc.comment_id) from general_comments gc, cr_revisions cr