Divergence between date_created in db and in UI

[casimiro]

Dear users,

I am using soap to create an entry of a custom module. When I create an entry I set, among other things, the field date_entered to some valid datetime. The problem is that the date_entered displayed later is not equal to the value I inserted. But, checking the records on MySQL I can see the value that I inserted.

I hope I was clear enough. Just in case, here is an example of this problem:
In the db record, the date_entered is:
2010-08-11 11:32:00
But in the GUI:
08/11/2010 08:32

 // Here is the code I call to create the entry
$data = array(
        'name' => $status->name,
        'description' => $status->description,
        'date_entered' => $status->dateEntered // It's a date('Y-m-d H:i:s',$time)
        );
        $name_value_list = array();
 
        foreach($data as $key => $value)
                array_push($name_value_list, array('name' => $key, 'value' => $value));
 
        $status_id = $this->soap->call('set_entry', array(
                'session' => $this->ses,
                'module_name' => 'geral_statuspartner',
                'name_value_list' => $name_value_list)); 
  

Thanks,
Caio.

[Angel]

Dates in Sugar are always stored in UTC, and the UI compensates accordingly based on the time zone of the logged in user.

If you store your values in UTC as well, it will display correctly in the UI.

[casimiro]

Thank you very much!