title: SQL Server: Best practices to save datetime with different timezone in database
body: <p>I would like to save DateTime with TimeZone associated.</p>
  <p>I have an order and for each order, tracking timezone is different and wants to convert it to UTC timezone and also to the local timezone.</p>
  <p>So original time always different for each order and want to save the DateTime with a different timezone.</p>
  <p>What is the preferred way of handling this kind of situation?</p>