oracle9.2 SELECT p.process_id, p.one_line, p.description, p.party_id, to_char(p.creation_date,'YYYY-MM-DD') as creation_date_ansi FROM pm_process p ORDER BY p.one_line