title: DateTimeOffset Sample in SQL 2008R2
body: <p>I have a doubt related to using <code>datetimeoffset</code> in SQL server 2008 r2.</p>
  
  <p>Suppose I have a web application, the db server in Spain and the client is in Canada. I don't know the time zone between Spain and Canada but suppose its 5 hours more in Spain.
  So user in Canada wants to add a new Employee at 23:00 PM, when clicks save, it calls a stored procedure that inside call the function <code>SYSDATETIMEOFFSET()</code> to fill the column <code>CreatedDate</code> that has a datatype <code>datetimeoffset(7)</code>. </p>
  
  <p>In this case, what will be the datetime saved in the database? and How should I do to show the right datetime to the user in Canada that wants to check the <code>CreatedDate</code>? Is there any good example to check this?</p>