How to catch the current year on ORACLE?

Question

I need to get the annual year on ORACLE, but I only know how to get the current date, so:

SELECT SYSDATE FROM DUAL

You can manipulate it to get only the Year?

Answer 1

The function EXTRACT allows extracting different parts of a field or variable containing date, time or range.

To get the current date, use the snippet EXTRACT(YEAR FROM sysdate), as in the query for example:

select EXTRACT(YEAR FROM sysdate) from dual;

Answer 2

Using to_char:

select to_char(sysdate, 'YYYY') from dual;