oracle8.1.6 select to_char(creation_date, 'DD/MM/YYYY') from acs_objects where object_id = :response_id