I'm trying to figure out how to use a YEAR entered via a prompt in a date selection criteria... so the user enters 2018 for the Balance_Year... and I want to look for the TAXFORM_DED record with an EFFDT between 01/01/YEAR and 31/12/YEAR. Where YEAR = Prompt value?
1 Answers
using the extract syntax might work.
e.g.
select effdt
from taxform_ded
where extract(year from effdt) between :1 AND :2
Here's a demonstration: https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=d33f938fbb1428058cad54f74134bd28
references:
Related