oracle8.1.6 archive_date <= sysdate and release_date <= sysdate and (archive_date > sysdate or archive_date is null) select count(*) from press_items_approved where archive_date <= sysdate