title: MSSQL 2014 Change returned Date in a different time zone
body: <p>I have a query that returns a date as one of the column however I need that date to be in a different time zone then it currently is.</p>
  <pre><code> SELECT ISNULL(Value, 'NULL') AS VALUE, ISNULL(UPPER(FORMAT(start_date), 'MMM dd, yyyy hh:mm ')), 'NULL') as Start_Date FROM MY TABLE
  </code></pre>
  <p><a href="https://i.stack.imgur.com/HPm8n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HPm8n.png" alt="enter image description here" /></a></p>
  <p>I tried just to off set by 1 hour to make the time as in central time (currently its EST)</p>
  <pre><code>   DATEADD(hh, -1, start_date)
  </code></pre>
  <p>the the problem comes when the date is inside daylight saving time and all returned dates within that time fate are being offest by 1 hour
  Is there a way to convert that start_date column to accommodate for it?</p>