title: SQL Server: replace year of datetime with current year in Select
body: <p>I am selecting data using the following stored procedure with dateDT being saved as datetime. </p>
  
  <p>Can someone here tell me how I can replace the year in the below Convert results so that this is always the current year (independent of the year it is saved under in the table) ?</p>
  
  <pre><code>SELECT      dateID,
              CONVERT(VARCHAR(11), dateDT, 106) AS dateDT,
              CONVERT(VARCHAR(10), dateDT, 126) AS dateDTShort,
              countries,
              regions
  FROM        DaysFixed
  WHERE       countries LIKE '%'+@selCountry+'%'
  OR          regions LIKE '%'+@selCountry+'%'
  ORDER BY    dateID
  FOR XML PATH('datesDT'), ELEMENTS, TYPE, ROOT('root')
  </code></pre>
  
  <p>Many thanks in advance, Mike. </p>