Time Zone Offset

Previous  Top  Next

Many times, the server or hosting service is located in a different time zone than where the merchant is located. Also, many servers are set to Grenich Mean Time (GMT). Unless something is done to compensate for the difference, the time stamp for orders and stats will show a different time than your local time. To adjust this so that time stamps and stats are in sync with your local time zone,

1.	Open the database using a tool such as phpMyAdmin.

2.	Browse the database table 'preferences'.

3.	Edit the 'timezoneoffset' record.

4.	Enter the difference of time between your time zone and the server time in seconds.

5.	For instance: If server time is 3 hours later than your time zone, enter '-10800' (minus 10800, 3 hours x 60 minutes x 60 seconds). If the server time is 2 hours earlier than your time zone, enter '7200' (2 hours x 60 minutes x 60 seconds).