sql - Oracle : YEAR Keyword invalid

Question

I have dates stored in the price_date column in one of my oracle tables. I need to filter records that belong to the year 2014 for e.g

select * from MIS_PERMAL.MV_INDEX_PERFORMANCE 
where index_id = 1045 and YEAR(PRICE_DATE) = 2014

I am getting error saying YEAR is invalid.

Answer 1

Oracle doesn't have a year() function. You seem to have got that syntax from a different database (like MySQL).

You can use the extract() function instead:

select * from MIS_PERMAL.MV_INDEX_PERFORMANCE
where index_id = 1045
and EXTRACT(YEAR from PRICE_DATE) = 2014