title: How to convert a float column into a datetime
body: <p>I have a table that contains a DateField(DataType : DateTime) and TimeField(DataType : Float)
  My output should be DateTime . My tables are in SQL Server 2008</p>
  
  <p>Here is an example :</p>
  
  <p>Table A</p>
  
  <pre><code>ID  StartDate                            StartTime
  1   2012-06-08 00:00:00.000              1223
  2   2012-08-07 00:00:00.000              910
  3   2012-05-02 00:00:00.000              1614
  4   0094-07-13 00:00:00.000              1245
  5   1994-04-18 00.00:00.000              2573
  </code></pre>
  
  <p>I need to get my output in such a way that I should it should validate for the correct time and correct date and append these two and insert into table B</p>
  
  <p>Table B :</p>
  
  <pre><code>ID    StartDateTime
  1     2012-06-06 12:23:00.000
  2     2012-08-07 09:10:00.000
  3     2012-05-02 16:14:00.000
  </code></pre>
  
  <p>Note that I intentionally left rows 4 and 5 out of the result set; these rows should be ignored because they don't contain valid datetime or time data.</p>