title: DateTimeOffset Stored as GMT Convert To Central Time
body: <p>Is there a way in T-SQL to Convert GMT To Central Time that compensates for Daylight Saving.</p>
  
  <p>It seems that <code>SWITCHOFFSET</code> only accepts a string in the format <code>[+|-]TZH:TZM</code> or a signed integer (of minutes) that represents the time zone offset, and is assumed to be daylight-saving aware and adjusted.</p>