title: Convert SQL Server DateTimeOffset to Time Zone
body: <p>Is it possible in a SQL Server Query to convert a datetimeoffset to it's corresponding timezone?  For example, I have values stored as:</p>
  
  <p>2015-01-03 00:30 -06:00</p>
  
  <p>2015-01-10 00:30 -05:00</p>
  
  <p>I want my sql query to display -06:00 as CST or CDT and -05:00 as EST or EDT if daylight savings is in effect.</p>
  
  <p>I'm coding an RSS Feed where I ultimately want my result set column to display:</p>
  
  <p>Fri, 02 Jan 2015 18:30 CST</p>
  
  <p>Fri, 09 Jan 2015 18:30 EST</p>
  
  <p>Any help would be greatly appreciated. Thanks!</p>