title: How to change time zone in MYSQL database?
body: <p>I have a table <code>myTable</code> in my <code>MYSQL database</code> in which there is a column called <code>INSERT_DATE</code> which is <code>datetime</code> type and having a default value of <code>CURRENT_TIMESTAMP</code>. </p>
  
  <p>While making an insert statement, this column automatically picks the current time from my system. </p>
  
  <p>This is working very well on my localhost. But when I hosted my website to a server placed somewhere else in some different timezone, its picking time from that time zone which is wrong. I want to set timezone to <code>GMT + 5:30</code> <code>('Asia/Kolkata')</code>. How can I achieve this in <code>MYSQL</code>?</p>
  
  <p>I am trying to change timezone while connecting to database, but it is not working. Below is my code:</p>
  
  <pre><code>function connect_database()
  {
      $con = mysqli_connect("servername", "username", "password", "dbname");
      if (!$con) 
      {
          $con = "";
          echo("Database connection failed: " . mysqli_connect_error());
      }
      mysqli_query($con, "SET SESSION time_zone = 'Asia/Kolkata'");
      return $con;
  } 
  </code></pre>