Answers.Body: <p>Try setting your preferred timezone in <code>civicrm.settings.php</code> and/or <code>wp-config.php</code>?</p>
  
  <pre><code>ini_set('date.timezone', 'Asia/Calcutta');
  </code></pre>
  
  <p>You might want to adapt the timezone you set as appropriate to your MySQL server.</p>
  
  <pre><code>mysql -e 'SELECT @@system_time_zone;'
  </code></pre>
  
  <p>I believe India does not observe daylight savings? For that and similar reasons it's probably better to match the timezones in both systems. If MySQL is set to UTC offset, use that for PHP, and if MySQL is set to a regional timezone, follow suit.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-20T11:30:11.453Z
Answers.LastActivityDate: 2017-07-20T20:07:26.647Z
Answers.LastEditDate: 2017-07-20T20:07:26.647Z
Answers.UserDisplayName: Chris Burgess
Body: <p>Facing this warning Timestamps reported by MySQL (eg "2017-07-20 13:48") and PHP (eg "2017-07-20 08:18" ) are mismatched.</p>
  
  <p>While MySql time matches with my local time. PHP is running 5:30 hrs less. My timezone is UTC+5:30 hrs. </p>
  
  <p>Tried below options,</p>
  
  <ol>
  <li>changing the setting in UI ( WAMP -> PHP settings) and also in PHP.ini. </li>
  <li>Wordpress settings</li>
  </ol>
  
  <p>Didnt seem to work. What else I need to try?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-08-20T17:57:56.407Z
Comments.Text: Possible duplicate of [Timestamp mismatch between MySQL and PHP](https://civicrm.stackexchange.com/questions/7527/timestamp-mismatch-between-mysql-and-php)
Comments.UserDisplayName: Jon G - Megaphone Tech
Tags: <settings><civicrm.settings.php><timezone><default-settings><timestamp>
Title: timezone in PHP is incorrect
ThreadText: # timezone in PHP is incorrect
  
  (Asked by: username_0 on 2017-07-20)
  
  Facing this warning Timestamps reported by MySQL (eg "2017-07-20 13:48") and PHP (eg "2017-07-20 08:18" ) are mismatched.
  
  While MySql time matches with my local time. PHP is running 5:30 hrs less. My timezone is UTC+5:30 hrs.
  
  Tried below options,
  
  1. changing the setting in UI ( WAMP -> PHP settings) and also in PHP.ini.
  2. Wordpress settings
  
  Didnt seem to work. What else I need to try?
  
  **Tags:** settings, civicrm.settings.php, timezone, default-settings, timestamp
  
  > **Comments:**
  > **username_1**: Possible duplicate of [Timestamp mismatch between MySQL and PHP](https://civicrm.stackexchange.com/questions/7527/timestamp-mismatch-between-mysql-and-php)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2017-07-20. Score: 3
  
  Try setting your preferred timezone in civicrm.settings.php and/or wp-config.php?
  ini_set('date.timezone', 'Asia/Calcutta');
  
  You might want to adapt the timezone you set as appropriate to your MySQL server.
  mysql -e 'SELECT @@system_time_zone;'
  
  I believe India does not observe daylight savings? For that and similar reasons it's probably better to match the timezones in both systems. If MySQL is set to UTC offset, use that for PHP, and if MySQL is set to a regional timezone, follow suit.
  
  
  ---
  
  