title: SQL Server: convert ((int)year,(int)month,(int)day) to Datetime
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/266924/create-a-date-with-t-sql">Create a date with T-SQL</a>  </p>
  </blockquote>
  
  <p>I've a data table that stores each year, month and day value as ints:</p>
  
  <pre><code>year | month | day
  2009 |   1   |  1 
  2008 |  12   |  2
  2007 |   5   |  5
  </code></pre>
  
  <p>I need to convert it to datetime value, because I need to use it in a datetime between operation. How could I do this?</p>