title: SQL Server regional settings database wise
body: <p>I have an SQL Server instance with 3 databases.  (A, B &amp; C).</p>
  
  <p>The operating system has regional / date &amp; time settings of India. </p>
  
  <p><strong>My requirement is  :</strong></p>
  
  <p>Database A should get regional settings of India.</p>
  
  <p>Database B should get regional settings of US.</p>
  
  <p>Database C should get regional settings of Dubai.</p>
  
  <p>Currently, I am concerned with date &amp; time only.</p>
  
  <p>So, If I execute the query on the different databases: </p>
  
  <pre><code>Select getdate()
  </code></pre>
  
  <p>It should return the date &amp; time based on the database's regional setting (which i am trying to find how to set).</p>
  
  <p>For Eg : The Operating System's Current Date &amp; Time is 3rd November  6:18 pm </p>
  
  <p>Database A (India Time) should Give 3rd November  6:18 pm </p>
  
  <p>Database B (US Time) should Give 3rd November  7:49 pm</p>
  
  <p>Database C (Dubai Time) should Give 3rd November  4:49 pm</p>
  
  <p>I am unsure about how do I change the settings database wise from server or by passing some parameters via connection string or is it really possible to accomplish this.</p>
  
  <p>or I would have to write my own function for doing this.</p>