You can construct CYYDDD format for the current date as:

floor((extract(year from sysdate) - 1900) / 100) || to_char(sysdate, 'RRDDD')

You can then use this in a WHERE clause:

jdate < floor((extract(year from sysdate) - 1900) / 100) || to_char(sysdate, 'RRDDD')

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top