oracle8.1.7 select testcase_id, package_key, to_char(timestamp,'MM/DD/YYYY HH:MI:SS') timestamp, passes, fails from aa_test_final_results