title: Setting time Zone in MS SQL Server Database
body: <p>i am using php with mssql, on windows azure cloud storage ,
  when i insert datetime with code then it insert</p>
  
  <pre><code> '2013-05-30 11:31:47.000'
  </code></pre>
  
  <p>(which is correct time with indian time zone)</p>
  
  <p>but when i use <code>getdate()</code> to insert in other column it inserts <code>'2013-05-30 06:01:46.507'</code></p>
  
  <ol>
  <li>any idea how can we set default time zone to indian delhi - with any database settings /azure ?</li>
  </ol>