Sugar/MySQL - 2 hours of difference

[piccirm2]

Hi

if I create a new task with a certain due date, in the table task the due_date is saved with 2 hours less
Any explanation of this ???
the sysdate on the windows server and on mysql are ok
Sugar version CE 5.0.0.0d

[DragonflyMaster]

Hi

if I create a new task with a certain due date, in the table task the due_date is saved with 2 hours less
Any explanation of this ???
the sysdate on the windows server and on mysql are ok
Sugar version CE 5.0.0.0d

Maybe there is a difference from Server and Client time.
Maybe one is set to use CET and the other GMT...

[piccirm2]

they are the exatcly the same

[mikesolomon]

they are the exatcly the same

what timezone are you in?

sugar saves dates in GMT

[piccirm2]

My zone is CET : GMT+1 (+DST)
can I change Sugar config in order to save date/time in my zone settings?

[mikesolomon]

My zone is CET : GMT+1 (+DST)
can I change Sugar config in order to save date/time in my zone settings?

you can't

have a look at http://www.sugarcrm.com/forums/showt...&highlight=gmt it might help

[piccirm2]

ok
tks alot!