title: Convert Time zonoffset value to varchar
body: <p>Query:</p>
  
  <pre><code>DECLARE @TimeZoneOffset datetimeoffset
  SELECT @TimeZoneOffset  = Time_Zone_Offset 
  FROM OFFSET_TABLE WHERE Active=1
  </code></pre>
  
  <p><code>Time_Zone_Offset</code> column contains value like -6:00 (only offset)</p>
  
  <p>When I do <code>SELECT @TimeZoneOffset</code> it throws me an error</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>I know I am doing something wrong. I may need to <code>CONVERT/CAST</code> but can't get o/p so far.</p>
  
  <p>Any help</p>