How to change timezone settings for sugarcrm

[andreasbalzer]

Hi,
my server runs at american time, my company is located in Europe. If I change the timezone in user settings it doesn't have any effect. Is there a sugarcrm wide setting somewhere?

Greetings,
Andreas

[roblaus]

I just checked - mine is in the US as well (slicehost) but it runs GMT. My Sugar time is correct (+2). Database entries are the same as server time and Sugar ads the two hours. I didn't do anything else but setting the user time zone.
rgds

[andreasbalzer]

Hi,
well my server doesn't run GMT but SugarCRM should. How to manage that?

[roblaus]

Did you check the database directly? Which time does it show if you change an entry right now?
I did set up quite a few Sugar instances but as I said - I never changed anything apart from the user time zone.

[dnewsom]

My server is running MST (-7) and when I update a row the modified time is correct. However when I try to enter a call, it inserts it into the database as GMT. Is there any way around this?

[dnewsom]

I am still looking for some help with this issue.
The database is showing GMT time, the call itself when you open it shows the correct time it was inserted for, but you can't search for that call because of the database being in GMT and the search does not take that into account.
I'm working on SugarCRM v5.1, PHP 5.2.4, MySQL 5.0.51 on a Ubuntu server system.

[aslon]

please help me...
is there any solutions about this ?

[datasponge]

All dates and times should be (are) stored as GMT in Sugar.

The search should have you to enter your local times, translate them to GMT and match them against GMT in the database. If it doesn't it it likely a bug.

It would need to operate this way to have a uniform way of matching records when they are being created and edited from different timezones across the globe.

What exact behavior are you seeing when you search? Please give a specific example of what you search for and what date/time does not match that you believe should match.

Phil

[Crue1z]

Go to admin - > System Settings . Im having a problem regarding the timezone. Doesnt matter what i change the timezone to as user or in system settings the timezone in the Database remains writing GMT +0 timezone format . So for eg. If i create a Contact the date_entered on the front value will be say 16-07-2010 11:00am when i create it at 11:00am which is fine. But if i search for that contact in the DB i find it keeps writing the TIME 2 hours earlier .

PS this is if my timezone is on Africa/Johannesburg GMT +2. If i change it to GMT anything whether its GMT +4 or GMT -6 the DB still put the time on GMT +0

Any ideas how to fix this ?

Thanks in advance!
Crue1z

[roblaus]

If you read what was written above things would be clearer.

The time in the database is ALWAYS GMT. Because there must be some reference time. So if you enter as meeting time 9am and you are on GMT+2 a naked database query will show 7am. This must be like that because another user who is on GMT +4 will see the meeting time (imagine it is a phone conference) as 7+4 = 11a. Which guarantees that both of you pick up the phone at the same time.

It's a different story though if you plan to use direct db queries for e.g. an interface to another system. Then you need to check the owner of the record, his or her time zone and then adjust the result set accordingly before you write to another system.