title: How do I concatenate numbers to create a custom date?
body: <p>Here is what I have tried thus far:</p>
  
  <pre><code>select CAST(
      DATEPART(month,getDate())+'-'+
      DATEPART(day,getDate())+'-'+
      2012
      as datetime)
  </code></pre>
  
  <p>I end up with the date: 1905-08-02 00:00:00.0. I was expecting to get today's date. I have rearranged the order and it doesn't seem to change. Can anyone offer as to why it gives me this? For the record, I plan to use other values than 2012 for the year.
  Thanks in advance.</p>