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.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…