postgresql7.3 SELECT p.process_id, p.one_line, p.description, p.party_id, to_char(p.creation_date,'Mon DD ''YY') as creation_date FROM pm_process p ORDER BY p.one_line