title: Select a specific date for the current year
body: <p>I have a query that needs to select <code>{current year}-05-31 00:00:000</code>. Is there a way I can do it <strong>without</strong> just concatenating the year on to that string?</p>
  
  <p>Here's my current query:</p>
  
  <pre><code>SELECT DATEADD(dd, 30, DATEADD(mm, 4, DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)))
  </code></pre>