title: How to consider timezones in a bridge
body: <p>I need to transfer records between two systems based on their time. </p>
  
  <p>One end is an sql server database, and the datefields (currently) have <code>datetime</code> columns with values filled from <code>getdate()</code> - no timezone info anywhere. The field is called <code>upddate</code>.</p>
  
  <p>The other end is an api to another database. It returns JSON files in which the date properties are like this:
  <code>"registeredAt": "2018-11-29T08:41:17.214+0000"</code></p>
  
  <p>This last one seems fortunately to include timezone info. The question, then, is: What should I apply to the sql server's <code>upddate</code> field in order to compare it to a <code>registeredAt</code> value?</p>
  
  <p>By searching around I found the <code>datetimeoffset</code> type that might be of use - however, I am very buffled by the fact that <code>select convert(datetimeoffset,getdate(),127)</code> returns a result with +00:00 in the end, despite the server being on a non-zero offset timezone.</p>