<div>
Records older than 24 hours would include records older than 48 hours. Can you describe how you would like the output to be?
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a table with field INSERT_DATE&quot; TIMESTAMP(6), adding the date/time when the record was inserted.<br />
&nbsp;I need to list the records older than 24 and 48 hours...<br />
Thank you
</div>
</div>


Hi,
I have a table with field INSERT_DATE" TIMESTAMP(6), adding the date/time when the record was inserted.
 I need to list the records older than 24 and 48 hours...
Thank you

ORACLE DATE / TIME

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.