Check if date is greater than 2000 in PL/SQL
How to check if the date is greater than the year 2000 in PL/SQL?
IF (TO_CHAR(date_val,'YYYY') > '2000') THENAnother option is to use the TO_DATE function to convert the comparison string to a date value.END IF;
IF (date_val > TO_DATE('12/31/2000','MM/DD/YYYY')) THENEND IF;