oracle8.1.6 select to_char(sysdate,'DD Mon YYYY hh12:MI am') from dual select * from (select entry_id, e.title, e.content, to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi, c.name as category from pinds_blog_entries e, pinds_blog_categories c where e.package_id = :package_id and e.draft_p = 'f' and e.deleted_p = 'f' and c.category_id = e.category_id (+) order by e.entry_date desc, e.posted_date desc) where rownum < 11 select * from (select e.entry_id, e.title, e.content, to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi, c.name as category from pinds_blog_entries e, acs_objects o, users u, pinds_blog_categories c where e.package_id = :package_id and o.object_id = e.entry_id and o.creation_user = :user_id and u.user_id = o.creation_user and e.draft_p = 'f' and e.deleted_p = 'f' and c.category_id = e.category_id (+) order by e.entry_date desc, e.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' select nvl ((max(posted_date)-to_date('1970-01-01'))*60*60*24,0) as last_update from pinds_blog_entries e join acs_objects o on (o.object_id = e.entry_id) where e.package_id = :package_id and o.creation_user = :user_id and e.draft_p = 'f' and e.deleted_p = 'f'