title: Sql server and browser timezone calculation
body: <p>Following are the timezone values :</p>
  
  <pre><code>SELECT * FROM sys.time_zone_info
  </code></pre>
  
  <p>In Javascript, how to populate and match the timezone at DB for calculation? I also have multiple timezones, also need to work in all browsers</p>
  
  <p>Daylight saving also needs to be considered.</p>
  
  <p>I need a dropdown at client side for timezone and that timezone should work with SQL server timezone info, so I can use the following query,</p>
  
  <pre><code>SELECT CONVERT(datetime,'20160101 00:00') AT TIME ZONE 'Cen. Australia Standard Time';
  </code></pre>
  
  <p>How can I auto select drop down base on browser timezone ? </p>