In Data Migrator's SQL filter, I would like to extract rows when it is less than 3 days old. So, I formulated the following:

(DAYS( CURRENT_TIMESTAMP(0)) - DAYS(T1.REP_DATE)) <= 2

T1.REP_DATE is the datetimestamp column which I am measuring against. But it does not work with no rows returned.

Question : is the date comparison correct?
Thanks
Lawrence

Database: Oracle
OS : Linux

Need to add an observation, when I click the 'Test SQL statement' in SQL object's column selection or filter, it got no rows returned. But if I run the flow, it does return rows. There is some inconsistency between the 'Test SQL statement' and the actual run.

The proper way is :

T1.REP_DATE >= CURRENT_TIMESTAMP(0 ) - 3 DAY