Index: openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql	8 Dec 2003 05:55:53 -0000	1.1
+++ openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql	14 Dec 2003 11:10:44 -0000	1.2
@@ -6,15 +6,14 @@
 <fullquery name="blogger.getRecentPosts.get_n_entries">
       <querytext>
         select * from 
-        ( select entry_id,
-               to_char(entry_date, 'YYYY-MM-DD') as entry_date,
-               content,
-               to_char(posted_date , 'HH24:MI') as posted_time_pretty
-		    from   pinds_blog_entries
-		    and    package_id = :package_id
-		    and    draft_p = 'f'
-		    and    deleted_p = 'f'
-		    order  by entry_date desc, posted_date desc
+         (select entry_id,
+                 to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi
+                 content,
+          from   pinds_blog_entries
+          and    package_id = :package_id
+          and    draft_p = 'f'
+          and    deleted_p = 'f'
+          order  by entry_date desc
         ) where rownum <= :numberOfPosts
       </querytext>
 </fullquery>