title: SQL SYSDATETIME and SYSUTCDATETIME
body: <p>I need to get the SQL Server date time and my local datetime.</p>
  
  <p>Assume my current time is 3.47 pm.</p>
  
  <p>Now I'm using SQL Server Management Studio which is installed in my local machine. And When I execute following commands it returns two different values.But Its OK since <code>SYSDATETIME</code> 'll return server datetime and 
  <code>SYSUTCDATETIME</code> 'll return local datetime.</p>
  
  <pre><code>SELECT SYSDATETIME()
  SELECT SYSUTCDATETIME()
  </code></pre>
  
  <p>Return Values are</p>
  
  <blockquote>
    <p>2015-07-23 12:17:03.2686085</p>
  </blockquote>
  
  <p>And</p>
  
  <blockquote>
    <p>2015-07-23 10:17:03.2686085</p>
  </blockquote>
  
  <p>But the problem is the value I'm getting from <code>SYSUTCDATETIME</code> is not equal to my local datetime.</p>
  
  <p>How can that happen?</p>