[Solved] Oracle : YEAR Keyword invalid

by


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

1

solved Oracle : YEAR Keyword invalid