oracle8.1.6 select to_char(sysdate, 'YYYY-MM-DD') from dual select to_char(sysdate, 'HH24:MI:SS') from dual select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name, ss.subsubcategory_id, ss.subsubcategory_name from ec_categories c, ec_subcategories s, ec_subsubcategories ss where c.category_id = s.category_id (+) and s.subcategory_id = ss.subcategory_id (+) order by c.sort_key, s.sort_key, ss.sort_key