title: How to filter results based on year in date field in Oracle SQL?
body: <p>So I'm writing a program which, when given user input, (using JDBC), of a year will return all the orders of that given year. I'm storing the date as 'OrderPlaced' in my Orders table with format 'dd-MMM-YY'. However, I'm a bit stumped how to go about retrieving the information based solely on the year of entry. Would it be with the use of a LIKE statement? or is there an in-built way in which I could filter dates in oracle?<br>
  Thanks in advance :)</p>