title: now() function in mysqli php
body: <p>I'm using <code>now()</code> to insert the current date time in the database while inserting/updating a table. The code is working fine, but there is only one issue, the date time inserted by php is not in Indian time. I think it is taking the default UTC time.</p>
  
  <p>I have used</p>
  
  <pre><code>date_default_timezone_set('Asia/Calcutta');
  
   insert into emp_req (ereid,erdid,ersdate,erstime,eredate,eretime,ercid,erattach,ersub,ermess,erdate,ercats,erip) values ('$eid','$dept','$sdate','$stime','$edate','$etime','$geputcomp','$attach','$sub','$message',now(),'$cats','$ip_user')
  </code></pre>
  
  <p>but in spite of using the default date time, I am getting another time ...</p>
  
  <p><strong>Please note - 
  I can not use the date function, because I have use the same code in other places and I want a solution for this without change the <code>now()</code> function.</strong></p>