title: Timezone Incorrect by 30mins
body: <p>My SQL Server appears to be on AU ESDT instead of AU ACSDT time, however the Server (Server 2008) has the correct timezone on AU ACSDT, is there any way to find and resolve the problem?</p>
  
  <p>When I run:</p>
  
  <pre><code>SELECT GETUTCDATE(), GETDATE(), DATEDIFF(HOUR, GETDATE(), GETUTCDATE()) ;
  </code></pre>
  
  <p>The results that I get are:</p>
  
  <pre><code>2010-12-06 01:47:57.207 2010-12-06 12:17:57.207 -11
  </code></pre>
  
  <p>A DB I have stores its dates in UTC format and when I calculate the correct TZ offset it is always off by 30mins.</p>
  
  <p>Any assistance is greatly appreciated.</p>
  
  <p><strong>Environment:</strong>
  SQL Server 2005 x64 SP3 (9.0.4035)
  MS Server 2008 x64 SP1</p>