CODEWITHSUNDEEP
oracle-databaseoas
Oleg
Oleg

Reputation: 41

OAS date filter expression

I want limit data by day of last date in table(not sysdate), but all I try is not successful. With SQL it can be achieved as

SELECT * FROM INFO WHERE TRUNC (CHECK_TIME) = (SELECT MAX (TRUNC (CHECK_TIME)) FROM INFO)

at filter expression I wrote something like this

TIMESTAMPDIFF(SQL_TSI_DAY, ExtractDay(CHECK_TIME), (ExtractDay(MAX(CHECK_TIME))))=0

but filter doesn`t work as I think. Could somebody help please?

Upvotes: 0

Views: 364

Answers (0)

Related Questions