Answers.Body: <p>Mailing clicks and opens are registered via scripts in extern (which are quite old) - and don't appear to use the cms environment - as such if the timezone isn't set for php and has defaulted to UTC - this won't show in the warnings - despite it being the issue. To detect this compare the result of php  To confirm this is the problem run </p>
  
  <pre><code>php -r 'echo date_default_timezone_get() . PHP_EOL;'
  </code></pre>
  
  <p>if the result is UTC - then you can fix by setting the date.timezone value correctly in your php.ini or similar file. </p>
  
  <p>This won't resolve historical data but will mean clicks and opens in the future are recorded in the correct timezone.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-20T02:36:35.573Z
Answers.LastActivityDate: 2018-12-20T02:36:35.573Z
Answers.UserDisplayName: Luke Stewart
Body: <p>The mailing and click tracking reports are showing times in UTC. There is no PHP MySQL timezone mismatch - and <code>mysql -e 'select now()'</code> and <code>date</code> return the right times - as per timezone.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-01-04T05:51:53.990Z
Comments.Text: Having the same issue.
  Another thing I noticed is that when I create contribution pages and set ending date it ends 8 hours early...
  Set time zone in PHP correct and set timezone in WP CMS correct...
  It's really annoying.
Comments.UserDisplayName: netzih
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-01-05T17:14:56.607Z
Comments.Text: Welcome to StackExchange! You have posted this as an answer, but it doesn't appear to answer the original question.  If the other answer doesn't help and/or you have a different question you would be better off posting this as a new question.  This isn't a forum and you are unlikely to get answers if you post here.
Comments.UserDisplayName: William Mortada
Tags: <civimail><civireport><php><timezone>
Title: Why do click and open reports show times in UTC rather than the site's timezone?
ThreadText: # Why do click and open reports show times in UTC rather than the site's timezone?
  
  (Asked by: username_0 on 2018-12-20)
  
  The mailing and click tracking reports are showing times in UTC. There is no PHP MySQL timezone mismatch - and `mysql -e 'select now()'` and `date` return the right times - as per timezone.
  
  **Tags:** civimail, civireport, php, timezone
  
  > **Comments:**
  > **username_1**: Having the same issue. Another thing I noticed is that when I create contribution pages and set ending date it ends 8 hours early... Set time zone in PHP correct and set timezone in WP CMS correct... It's really annoying.  
  > **username_2**: Welcome to StackExchange! You have posted this as an answer, but it doesn't appear to answer the original question.  If the other answer doesn't help and/or you have a different question you would be better off posting this as a new question.  This isn't a forum and you are unlikely to get answers if you post here.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2018-12-20. Score: 7 | Accepted answer
  
  Mailing clicks and opens are registered via scripts in extern (which are quite old) - and don't appear to use the cms environment - as such if the timezone isn't set for php and has defaulted to UTC - this won't show in the warnings - despite it being the issue. To detect this compare the result of php To confirm this is the problem run
  
  ```
  php -r 'echo date_default_timezone_get() . PHP_EOL;'
  
  ```
  
  if the result is UTC - then you can fix by setting the date.timezone value correctly in your php.ini or similar file.
  
  This won't resolve historical data but will mean clicks and opens in the future are recorded in the correct timezone.
  
  
  ---
  
  