title: How to set datetime timezone in stored procedure
body: <p>I have an SP with a bunch of queries that use datetime like <code>Getdate()</code>.</p>
  
  <p>Is there a way that I can set a global flag at the beginning of the SP to set a timezone offset for the datetimes?</p>
  
  <p>I need something like the <code>set dateformat dmy</code>, but to offset the timezone. </p>