How to compare with sysdate in extractor
I need to compare with function like sysdate in extractor , I tried DATENOW() but it failed. I need to add condition like below
table USER1.T_TRANSACTIONTRACE, WHERE ( LASTMODIFIEDTIMESTAMP > @DATENOW () -1 );
if I used below syntax , it work fine , but date here is fixed
table USER1.T_TRANSACTIONTRACE, WHERE (LASTMODIFIEDTIMESTAMP > '2025-04-24 00:00:00')