oracle8.1.6 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 ) where rownum <= :numberOfPosts