Answers.Body: <p>As long as your PHP and MySQL settings are correctly set (CiviCRM should warn you if they are not), you can set the server time to your preference. Using UTC for the server is probably more convenient on the long term, but it's not a CiviCRM requirement. For example, lets say you are in UTC-8, but next year a new sysadmin joins your team and is in UTC+6, UTC-8 will probably be pretty annoying (CiviCRM servers were initially on PCT time, before being changed to UTC).</p>
  
  <p>The biggest issue with time in CiviCRM is with CiviMail scheduled mailings and with scheduled reminders.</p>
  
  <p>If you are using Drupal or WordPress, CiviCRM should use the user's timezone settings and adjust time inputs/outputs accordingly. Otherwise you will have issues with the mailings not being sent at the right time (from the point of view of the user).</p>
  
  <p>Eileen and Jamie have posted a good wrap-up of this issue here:<br>
  <a href="https://issues.civicrm.org/jira/browse/CRM-9683?focusedCommentId=67732&amp;page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-67732" rel="nofollow">https://issues.civicrm.org/jira/browse/CRM-9683?focusedCommentId=67732&amp;page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-67732</a></p>
  
  <p>There is one detail with the timestamp field type that I do not really understand. i.e. if it's necessary to convert the field so that the fixes already committed work. Hopefully someone else can chime in.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-26T16:58:31.110Z
Answers.LastActivityDate: 2015-10-26T16:58:31.110Z
Answers.UserDisplayName: bgm
Body: <p>We run a Civicrm installation that spans a continent (a long way from UTC).</p>
  
  <p>What is the best practice?</p>
  
  <ol>
  <li>What time should our server be set to? </li>
  <li>How do we manage user timezones? </li>
  <li>What time should go in the database?</li>
  </ol>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-12-22T17:04:41.800Z
Comments.Text: Related question: http://civicrm.stackexchange.com/questions/7586/does-the-timestamp-mismatch-error-cause-any-real-problems
Comments.UserDisplayName: William Mortada
Tags: <sysadmin><timezone>
Title: What timezones should we use on the server and database?
ThreadText: # What timezones should we use on the server and database?
  
  (Asked by: username_0 on 2015-10-26)
  
  We run a Civicrm installation that spans a continent (a long way from UTC).
  
  What is the best practice?
  
  1. What time should our server be set to?
  2. How do we manage user timezones?
  3. What time should go in the database?
  
  **Tags:** sysadmin, timezone
  
  > **Comments:**
  > **username_1**: Related question: http://civicrm.stackexchange.com/questions/7586/does-the-timestamp-mismatch-error-cause-any-real-problems  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2015-10-26. Score: 3
  
  As long as your PHP and MySQL settings are correctly set (CiviCRM should warn you if they are not), you can set the server time to your preference. Using UTC for the server is probably more convenient on the long term, but it's not a CiviCRM requirement. For example, lets say you are in UTC-8, but next year a new sysadmin joins your team and is in UTC+6, UTC-8 will probably be pretty annoying (CiviCRM servers were initially on PCT time, before being changed to UTC).
  
  The biggest issue with time in CiviCRM is with CiviMail scheduled mailings and with scheduled reminders.
  
  If you are using Drupal or WordPress, CiviCRM should use the user's timezone settings and adjust time inputs/outputs accordingly. Otherwise you will have issues with the mailings not being sent at the right time (from the point of view of the user).
  
  Eileen and Jamie have posted a good wrap-up of this issue here:  
  <https://issues.civicrm.org/jira/browse/CRM-9683?focusedCommentId=67732&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-67732>
  
  There is one detail with the timestamp field type that I do not really understand. i.e. if it's necessary to convert the field so that the fixes already committed work. Hopefully someone else can chime in.
  
  
  ---
  
  