postgresql7.2 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