Answers.Body: <p>I've found link go to Doctorw Wen in CiviCRM (WordPress version) by go to Administrator Menu and fix the notice "Timestamps and Timezones", Thanks! </p>
  
  <p><a href="https://i.sstatic.net/G58xs.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/G58xs.png" alt="Menu go to Doctor When"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-15T23:21:44.960Z
Answers.LastActivityDate: 2018-01-15T23:21:44.960Z
Answers.UserDisplayName: ToanLuong
Answers.Body: <p>Applying the patches mentioned in the commits information <a href="https://issues.civicrm.org/jira/browse/CRM-21157?devStatusDetailDialog=repository" rel="nofollow noreferrer">here</a> will fix your problem for civicrm_subscription_history.date column. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-16T21:57:41.900Z
Answers.LastActivityDate: 2018-01-16T21:57:41.900Z
Answers.UserDisplayName: Hassan Farooq
Body: <p>I've update my CiviCRM from 4.7.24 to 4.7.29 (my CiviCRM system on WordPress), everything seems ok but I have System Status Notice: </p>
  
  <p>Timestamps and Timezones</p>
  
  <p>This MySQL database stores certain fields with data-type "DATETIME". To improve timezone support, you may want to change these from "DATETIME" to "TIMESTAMP".</p>
  
  <p>civicrm_subscription_history.date (New sites default to TIMESTAMP in v4.7.27+) [CRM-21157] (<a href="https://issues.civicrm.org/jira/browse/CRM-21157" rel="nofollow noreferrer">https://issues.civicrm.org/jira/browse/CRM-21157</a>)</p>
  
  <p>Changing should improve data-quality for organizations working in multiple timezones. However, if you do change, then you may need to re-test any customizations or processes that reference these fields. Changing is suggested but not required.</p>
  
  <p>For further discussion, please visit <a href="https://github.com/civicrm/org.civicrm.doctorwhen" rel="nofollow noreferrer">https://github.com/civicrm/org.civicrm.doctorwhen</a></p>
  
  <p>How can I do to pass this notice?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-01-14T13:26:46.850Z
Comments.Text: Here is the documentation for this https://github.com/civicrm/org.civicrm.doctorwhen/blob/master/README.md
Comments.UserDisplayName: Pradeep Nayak
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-01-14T22:10:36.570Z
Comments.Text: Thank for reply. I've uploaded doctorwhen extension and active, but I still don't know how to Usage (Web) because I'm still not familiar with CLI or PHP. I run link https://mywebsiteadress.com/civicrm/doctorwhen?reset=1 but not find this link
Comments.UserDisplayName: ToanLuong
Tags: <wordpress><status>
Title: System Status Notice about Timestamps and Timezones
ThreadText: # System Status Notice about Timestamps and Timezones
  
  (Asked by: username_0 on 2018-01-14)
  
  I've update my CiviCRM from 4.7.24 to 4.7.29 (my CiviCRM system on WordPress), everything seems ok but I have System Status Notice:
  
  Timestamps and Timezones
  
  This MySQL database stores certain fields with data-type "DATETIME". To improve timezone support, you may want to change these from "DATETIME" to "TIMESTAMP".
  
  civicrm\_subscription\_history.date (New sites default to TIMESTAMP in v4.7.27+) [CRM-21157] (<https://issues.civicrm.org/jira/browse/CRM-21157>)
  
  Changing should improve data-quality for organizations working in multiple timezones. However, if you do change, then you may need to re-test any customizations or processes that reference these fields. Changing is suggested but not required.
  
  For further discussion, please visit <https://github.com/civicrm/org.civicrm.doctorwhen>
  
  How can I do to pass this notice?
  
  **Tags:** wordpress, status
  
  > **Comments:**
  > **username_1**: Here is the documentation for this https://github.com/civicrm/org.civicrm.doctorwhen/blob/master/README.md  
  > **username_0**: Thank for reply. I've uploaded doctorwhen extension and active, but I still don't know how to Usage (Web) because I'm still not familiar with CLI or PHP. I run link https://mywebsiteadress.com/civicrm/doctorwhen?reset=1 but not find this link  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2018-01-15. Score: 2 | Accepted answer
  
  I've found link go to Doctorw Wen in CiviCRM (WordPress version) by go to Administrator Menu and fix the notice "Timestamps and Timezones", Thanks!
  
  [![Menu go to Doctor When](https://i.sstatic.net/G58xs.png)](https://i.sstatic.net/G58xs.png)
  
  
  ---
  
  ### Answer by username_2 on 2018-01-16. Score: 0
  
  Applying the patches mentioned in the commits information [here](https://issues.civicrm.org/jira/browse/CRM-21157?devStatusDetailDialog=repository) will fix your problem for civicrm\_subscription\_history.date column.
  
  
  ---
  
  