title: millisecond in sql tsql
body: <pre><code>SELECT
      CAST(‘2015-01-01 14:48:34.69’ AS DATETIME) FirstVal,
      CAST(‘2015-01-01 14:48:34:69’ AS DATETIME) SecondVal
  </code></pre>
  
  <p>When we look at the answer, there is a difference between the milliseconds part in the result set, whereas you can notice that in the <code>SELECT</code> statement I have specified different milliseconds part. The question is why there is a difference in the millisecond part even though I have different value selected?</p>
  
  <p><a href="https://i.stack.imgur.com/30IwP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/30IwP.png" alt="enter image description here"></a></p>