Andreja Zivkovic
asked on
ORACLE DATE / TIME
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Records older than 24 hours would include records older than 48 hours. Can you describe how you would like the output to be?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.