1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Updating Time Zone SQL

Discussion in 'XenForo Questions and Support' started by TheComputerGuy, Oct 19, 2014.

  1. TheComputerGuy

    TheComputerGuy Active Member

    Does anyone know the SQL code to update all members timezone?

    I did an import that did not go and import that, so everyone is in the England timezone.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_user SET timezone = 'Europe/London';
    Update the locale to suit.
     
  3. TheComputerGuy

    TheComputerGuy Active Member

    would it be 'Central Time' or 'Central Time (US & Canada)' ?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Central Time (US & Canada) is actually America/Chicago.
     
  5. TheComputerGuy

    TheComputerGuy Active Member

    Thank you Brogan. Worked perfectly.
     

Share This Page