title: SqlParameter Datetime SqlValue difference with Value
body: <p>I have a datetime value to pass into a <code>SqlParameter</code>.</p>
  
  <p><a href="http://i.stack.imgur.com/YKwbL.png" rel="nofollow">DateTime object value</a></p>
  
  <p>However when pass to <code>myCmd.Parameters.Add("@TrxDate", adt_TrxDate);</code></p>
  
  <p><a href="http://i.stack.imgur.com/dUl6L.png" rel="nofollow">SqlParameter SqlValue &amp; Value property is difference value</a></p>
  
  <p>Found that it add a day when executing query. I found this issue in profiler and finally find out <code>SqlParameter SqlValue</code> &amp; Value property is different value. Why it is happen and any idea?</p>