title: How I can extract year from a date in sql and use it in where clause
body: <p>I have a date column in a table which is named <code>released_date</code> and the format of its data is for example: <code>01-Jan-1995</code>. I want to have just the years which are greater than <code>1997</code>. Does anybody know how I can write such query?</p>