Database time differs from sugar interface!

[Tavares]

Hi!
I have what it seems to be a problem...i'm pushing some data from Sugar Database, and when i display this data in sugar it comes with a hour less that sugar displays in the DetailView of Case,notes....
I'm in portugal, i have configured all my timezone do Europe/Lisbon (GMT+0) (+DST) my database collation is utf8-general-ci-collation.

Am i missing something here?


Thanks

[Angel]

Don't you have to use GMT+1 instead to account for Daylight Savings Time (DST) ?

[JeanetteRoss]

I have the same issue in the UK - I have my time set for London.....With DST+0. Put in 3 and it goes in as 2.

I have had to alter all the reports.

[broon]

Same issue here.. I'm in the Eastern (EDT / new_york) US time zone and my time is off by 4 hours... Looks like it is set to GMT somewhere...

[broon]

OK... Pretty sure that THIS IS NOT A GOOD IDEA, however, you can modify SugarBean.php and fix this problem. This solution seems to work but is untested beyond creation of an Opportunity.


Old Code:

if(empty($this->date_modified) || $this->update_date_modified){
$this->date_modified = gmdate("Y-m-d H:i:s");
Modified to:

if(empty($this->date_modified) || $this->update_date_modified){
$gmt_offset = time()-14400;
$this->date_modified = gmdate("Y-m-d H:i:s",$gmt_offset);

where 14400 is -5 (US eastern time offset) * 60 * 60. This should be modified to your time zone.

I got this idea from http://us2.php.net/gmdate which might help.

Also note that this was done on 4.2.1a which is pretty old. It did however look the same in 4.5 but I did not test it...