oracle8.1.6 select g.comment_id, r.content, r.title, r.mime_type, acs_object.name(o.creation_user) as author, to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_ansi from general_comments g, cr_revisions r, cr_items ci, acs_objects o where g.object_id = :object_id and r.revision_id = ci.live_revision and ci.item_id = g.comment_id and o.object_id = g.comment_id order by o.creation_date