title: How to convert int to date in SQL Server 2008
body: <p>I am using MS SQL Server 2008,
  and in a table I have column idate as date but in the integer format.
  But in the query I want that in the date format.
  Is it possible to convert integer date into proper datetime format?</p>