Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER


Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE 11.2.0.2.0 Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production


CREATE TABLE TAXFORM_DED
    ("EFFDT" timestamp)
/
INSERT ALL 
    INTO TAXFORM_DED ("EFFDT")
         VALUES ('01-Jan-2010 12:00:00 AM')
    INTO TAXFORM_DED ("EFFDT")
         VALUES ('06-Jun-2013 12:00:00 AM')
    INTO TAXFORM_DED ("EFFDT")
         VALUES ('09-Sep-2019 12:00:00 AM')
SELECT * FROM dual
/
3 rows affected

select effdt
from taxform_ded
where extract(year from effdt) between 2012 AND 2018


EFFDT


06-JUN-13 12.00.00.000000 AM