title: start time of day with datetime string
body: <p>I believe that this is the start datetime of January the first 2012 expresses as a string/nvarchar:</p>
  
  <pre><code>SELECT CAST('2012-01-01 00:00:00.000' AS DATETIME)
  </code></pre>
  
  <p>It shows:</p>
  
  <pre><code>2012-01-01 00:00:00.000
  </code></pre>
  
  <p>If I do:</p>
  
  <pre><code>DECLARE @CutOffDateTime DATETIME
  SELECT @CutOffDateTime = CAST('2012-01-01 00:00:00.000' AS DATETIME)
  PRINT @CutOffDateTime 
  </code></pre>
  
  <p>It shows:</p>
  
  <pre><code>Jan  1 2012 12:00AM
  </code></pre>
  
  <p>which IMHO is the midday of January the first 2012. Is the above string correct? Why does print change the actual time?</p>