title: how to get time based on country in sql server
body: <pre><code>select getdate()
  </code></pre>
  
  <p>If we write this it gives server time, but I want the time based on country. Specifically, if I operate from India it should show time in India, and if I operate from Canada it should show time in Canada. </p>