[development] problem with custom date and timezones

[Seth Freach]

Lluís,

time() will return a value relative to the epoch, which is epicentered 
in GMT.
date() takes that value and returns a local time based on it.  IE, 
date() knows about the computer's timezone and takes it into account.

Drupal's format_date() function uses gmdate() internally, which, unlike 
date(), does not do local timezone offsetting. gmdate() returns the 
formated date string in GMT.  The reason format_date() does this is 
because it wants to return a time that has meaning to the individual 
user's location, which is not necessarily the computer's location, nor 
are all users always in the same timezone.  Drupal does the timezone 
offsetting itself to allow a system default timezone and individual user 
configurable timezones too.

Double check your Drupal timezone settings at q=admin/settings/date-time 
and possibly your user timezone settings at q=user/$uid/edit

Seth

Lluís wrote:
> Making some research my problem is with format date:
>
> $node->data_assentament -> 1247781600
> date("d-m-Y H:i", $node->data_assentament) -> 17-07-2009 00:00
> format_date($node->data_assentament,'medium') -> Dij, 07/16/2009 - 22:00
>
> (I need the date in dd/mm/YYYY format)
>
> Should I avoid format_date() or there is a better way to solve this?
>
> On Thu, Jul 16, 2009 at 5:40 PM, Lluís<enboig at gmail.com> wrote:
>   
>> I have created a custom node type. I have a date field which I created
>> as int in order to use it in views, being able to sort it, format,
>> etc....
>>
>> My problem right now is that when inserting a node with one date, it
>> appears as "day before" when viewing the node. How should I save it to
>> avoid this problem?
>>
>> My form looks like
>>  $arrayF=getdate(($node->data_paper>0 ? $node->data_paper : time()));
>>  $arrayF['month']=$arrayF['mon'];
>>  $arrayF['day']=$arrayF['mday'];
>>  $form['data_paper_array'] = array(
>>    '#type' => 'date',
>>    '#title' => 'Data Factura',
>>    '#default_value' => $arrayF,
>>    '#required' => TRUE,
>>    '#weight' => -9,
>>  );
>>
>> My insert query looks like
>>  $dateF=$node->data_paper_array;
>>  $factura_tmsp=mktime(0,0,0,$dateF['month'],$dateF['day'],$dateF['year']);//
>>  $date['year']."-".$date['month']."-".$date['day'];
>>  $node->data_paper=$factura_tmsp;
>>  db_query("INSERT ......);
>>
>> And my theme function:
>>  $output.="<li><b>Data Factura:</b>
>> ".format_date($node->data_paper,'small')."</li>";
>>
>>
>> Any hint/advice? Thanks
>>
>> --
>> *La vida és com una taronja, què esperes a exprimir-la?
>> *Si creus que l'educació és cara, prova la ignorància.
>> *La vida és com una moneda, la pots gastar en el que vulguis però
>> només una vegada.
>> *Abans d'imprimir aquest missatge, pensa en el medi ambient.
>>
>>     
>
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/development/attachments/20090717/9bef93c3/attachment.htm>