Index: openacs-4/packages/lars-blogger/www/blog-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/blog-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/lars-blogger/www/blog-oracle.xql	17 Oct 2003 00:39:22 -0000	1.5
+++ openacs-4/packages/lars-blogger/www/blog-oracle.xql	14 Dec 2003 11:10:44 -0000	1.6
@@ -18,9 +18,7 @@
     <fullquery name="all_blogs">
         <querytext>
 		    select entry_id,
-		           to_char(entry_date, 'fmDayfm, Month fmDDfm, YYYY') as entry_date_pretty, 
-		           to_char(entry_date, 'YYYY/MM/DD/') as entry_archive_url,
-		           to_char(entry_date, 'YYYY-MM-DD') as entry_date,
+		           to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi,
 		           title,
                            title_url,
 			   category_id,
@@ -30,7 +28,6 @@
 		           p.first_names as poster_first_names,
 		           p.last_name as poster_last_name,
 			   o.creation_user as user_id,
-		           to_char(posted_date , 'HH24:MI') as posted_time_pretty,
 		           (select count(gc.comment_id) 
 		            from general_comments gc, cr_revisions cr 
 		            where gc.object_id = entry_id
@@ -45,24 +42,21 @@
 		    and    draft_p = 'f'
 		    and    deleted_p = 'f'
                     [ad_decode $limit "" "" "and    rownum <= $limit"]
-		    order  by entry_date desc, posted_date desc
+		    order  by entry_date desc
         </querytext>
     </fullquery>
 
     <fullquery name="blog">
         <querytext>
 		    select entry_id,
-		           to_char(entry_date, 'fmDayfm, Month fmDDfm, YYYY') as entry_date_pretty, 
-		           to_char(entry_date, 'YYYY/MM/DD/') as entry_archive_url,
-		           to_char(entry_date, 'YYYY-MM-DD') as entry_date,
+		           to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi,
 		           title,
 		           content,
                            content_format,
 		           draft_p,
 		           p.first_names as poster_first_names,
 		           p.last_name as poster_last_name,
 			   o.creation_user as user_id,
-		           to_char(posted_date , 'HH24:MI') as posted_time_pretty,
 		           (select count(gc.comment_id) 
 		            from general_comments gc, cr_revisions cr 
 		            where gc.object_id = entry_id
@@ -78,7 +72,7 @@
 		    and    draft_p = 'f'
 		    and    deleted_p = 'f'
                     [ad_decode $limit "" "" "and    rownum <= $limit"]
-		    order  by entry_date desc, posted_date desc
+		    order  by entry_date desc
         </querytext>
     </fullquery>