title: SQL query for extracting year from a date
body: <p>I am trying to create a query that gets only the year from selected dates. I.e. <code>select ASOFDATE from PSASOFDATE;</code> returns <code>11/15/2012</code>, but I want only <code>2012</code>. How can I get only the year? I know the <code>YEAR</code> function can be used, but I'm not sure how.</p>