oracle8.1.6 sysdate between to_date(attributes.release_date, 'Month DD, YYYY') and to_date(attributes.archive_date, 'Month DD, YYYY') sysdate >= to_date(attributes.archive_date, 'Month DD, YYYY') to_date(attributes.release_date, 'Month DD, YYYY') desc