The reporting views contain information about table pairs, single-table constraints, join views, lookup views, SQL views, tests, and test runs. To extract information from the reporting views, you can build custom reports in a business intelligence tool or run SQL queries.
When you build a report, you specify an SQL query based on one or more reporting views. In the SQL query, you can transform the data based on the business requirements. For example, the results_summary_view contains the tr_start_time and tr_finish_time columns. The columns store the time in milliseconds since Jan 1, 1970.
You can run the following SQL statement to convert the milliseconds to a date and time format for a custom report:
SELECT TO_DATE('1970-01-01', 'YYYY-MM-DD')+(numtodsinterval(to_number(tr_finish_time)/1000,'SECOND'))