GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center