WHERE dob < add_months( trunc(sysdate), -12*20 );
would work assuming that you want to ignore the time component of sysdate
.
WHERE dob < add_months( trunc(sysdate), -12*20 );
would work assuming that you want to ignore the time component of sysdate
.