How to extract the year from a date in oracle?

@dedrick 

You can extract the year from a date in Oracle using the EXTRACT function or the TO_CHAR function.

1. Using EXTRACT:

1
2

SELECT EXTRACT(YEAR FROM your_date_column) AS year
FROM your_table;

1. Using TO_CHAR:

1
2

SELECT TO_CHAR(your_date_column, 'YYYY') AS year
FROM your_table;

Replace your_date_column and your_table with your actual column and table names. These queries will return the year as a numeric or string value, depending on which function you use.