Re: UK Daylight Savings Change

Adam Tauno Williams wrote:
> On Fri, 2008-10-31 at 03:27 +0100, Helge Hess wrote:
>   
>> On 30.10.2008, at 13:08, Ken Smith wrote:
>>     
>>> 1) Where is the data stored that tells OGo when these changes happen
>>>       
>> This is stored in the libFoundation timezone definitions.
>>     
>
> These files usually live somewhere like -
> /usr/local/share/libFoundation/TimeZoneInfo/
>
> If you correct/update a timezone please post a patch or at least the
> corrected file so the changes can be pushed.
>
>   
>>> 2) Is there an automated way to correct the entries in the database.
>>>       
>> The entries in the database are stored in UTC, w/o a timezone.
>>     
>
> You can pretty easily modify the timestamps in the PostgreSQL database
> with something like
>  /// Example
>  UPDATE date_x
>     SET start_date = start_date - INTERVAL '1 hour', 
>         end_date = end_date - INTERVAL '1 hour' 
>   WHERE start_date > '2008-08-25';
>   
> Of course, you should backup your data before making any manual changes,
> and be sure to qualify the start/end to fix based on the start/end of
> your timeszone's DST change (obviously the above is not correct).
>
>   
Thank you - I have found the settings on the system and they look to be 
correct. It would appear that the user has entered some incorrect data 
in to the system

Take care

Ken

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users