Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
370 views
in Technique[技术] by (71.8m points)

sql - Oracle : YEAR Keyword invalid

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...