You can use following SQL syntax to retrieve data in 5 minute interval in Oracle database.
select * FROM test_table where added_time <= systimestamp - numtodsinterval(5,'MINUTE')
Above SQL returns values which are older than 5 minutes than system time in added_time column.
No comments:
Post a Comment