Re: UK Daylight Savings Change

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).

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