oracle8.1.6 select to_char(sysdate,'DD Mon YYYY hh12:MI am') select * from (select entry_id, title, content, entry_date, posted_date, to_char(posted_date, 'YYYY-MM-DD') as posted_date_string, to_char(posted_date, 'HH:MI') as posted_time_string, to_char(entry_date, 'DD Mon YYYY hh12:MI am') as entry_date_pretty, to_char(entry_date, 'YYYY/MM/') as entry_archive_url from pinds_blog_entries where package_id = :package_id and draft_p = 'f' and deleted_p = 'f' order by entry_date desc, posted_date desc) where rownum < 11 select nvl ((max(posted_date)-to_date('1970-01-01'))*60*60*24,0) as last_update from pinds_blog_entries where package_id = :package_id and draft_p = 'f' and deleted_p = 'f'