title: Get current time and deal with daylight saving time for a particular timezone
body: <p>I am having trouble of using datetime in SQL Server 2012, my SQL database is hosted on a server that is using different timezone than the timezone I would like to use for my application, also my timezone I want to use is under daylight saving time, so I have to change the code every time this (daylight saving time) happens</p>
  
  <p>So if I use:</p>
  
  <pre><code>SELECT Getdate()
  </code></pre>
  
  <p>I will get current date and time of the server (wherever your database is hosted from), the result will be something like :</p>
  
  <blockquote>
    <p>2015-12-23 09:09:40.303</p>
  </blockquote>
  
  <p>Is there anyway or a built-in method in SQL that I can use to retrieve current date and time of particular timezone that also observes daylight saving time, or specifically in this case it is <strong>Central Standard Time</strong> (for USA), I would like it to take care of the daylight saving time automatically instead of having to manually modify the code every time the daylight saving time occurs.</p>