Skip to main content
  • EN

Hi,

So I have an oracle database with oracle timestamps as one of the columns. How can I make it so the reader only reads records between today and 7 days ago based on that timestamp? Otherwise I'll be reading millions of useless records

Thanks so much!

 

You can use a where-clause on the reader, e.g.

mytimestamp > sysdate-7

You can use a where-clause on the reader, e.g.

mytimestamp > sysdate-7
mytimestamp > trunc(sysdate - 7)
This is better if wanting the past 7 days rather than 168 hours ago

Or trunc(sysdate) - trunc(mytimestamp) < 8

In cases you use 7 you probably want the <= (less or equal).

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.