oracle – The first and last date of previous year
select TRUNC(SYSDATE - INTERVAL '1' YEAR,'YEAR') from dual;
--01.01.18
select TRUNC(SYSDATE,'YEAR') - 1 from dual;
--31.12.18
select TRUNC(SYSDATE - INTERVAL '1' YEAR,'YEAR') from dual;
--01.01.18
select TRUNC(SYSDATE,'YEAR') - 1 from dual;
--31.12.18