title: Checksum for datetime field in SQL
body: <p>Task: 
  We are validating the data in 2 different tables (of same structure). We tried to use the checksum function on the records for this.</p>
  
  <p>Problem:
  The records in the table are same. But when we use the checksum(*), it gives different CheckSum. </p>
  
  <pre><code>SELECT statusName,CheckSum(*) from OrderStatus
  </code></pre>
  
  <p>If i calculate the checksum, excluding the DateTime column, it gives the same value in both tables.</p>
  
  <pre><code>SELECT statusName,CheckSum(StatusName,CreatedByUser,ModifiedByUser) from OrderStatus
  </code></pre>
  
  <p>Columns in Tables:
  StatusName,CreatedByUser,ModifiedByUser,CreatedDateTime,LastModifiedTime</p>
  
  <p>How to resolve this, by including the datetime column.</p>
  
  <p>Any help is appreciated!!!!</p>