Hi All,
I have a table in Oracle database which updates continuously. So my requirement is to retrieve the data which got updated in last 15 minutes of the time. Would any one please help me out with Query. I have last_update_datetime_Stamp in the table.
Here is the query which i tried. But its not showing up the data
select * from Table where TO_DATE(IP.last_update_datetime_Stamp, 'YYYY-MM-DD HH24:MI:SS') > systimestamp - numtodsinterval(15,'MINUTE')
order by TO_DATE(IP.last_update_datetime_Stamp, 'YYYY-MM-DD HH24:MI:SS') desc;
And systimestamp is below:
24-DEC-19 04.46.35.447311000 AM -06:00
For example i have data update in between 4:30 - 4:45. And when i run the query at 4:46, i should be retrieving data which got updated 4:30 - 4:45. .