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
+10
You can use a where-clause on the reader, e.g.
mytimestamp > sysdate-7mytimestamp > trunc(sysdate - 7)
+12
Or trunc(sysdate) - trunc(mytimestamp) < 8
In cases you use 7 you probably want the <= (less or equal).
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
