[phpGroupWare-users] Re: Re: Re: Daylight Savings Time Issue

[adam williams]

cw wrote on Sat, 17 March 2007 16:07
> On 3/16/07, 
> 
> any entries between the new and old DST date change that were entered
> before the OS patch was applied will need to be adjusted.  The query
> above should work, just adjust the mdatetime to the date you applied
> the patch, if you can figure that out, or adjust it to include only
> the entries that off.
> 
> I still don't see how Jim's times flipflopped, quite baffeling.
> 
> Oh, and we aren't the only calendar software with this problem, even
> Outlook has to have its times adjusted.


gotcha, so looking at my linux /etc/localtime:

[mailto:address@hidden i586]# ls -l /etc/localtime
-rw-r--r--  2 root root 3543 Feb 13 15:23 /etc/localtime
[mailto:address@hidden i586]# php -r 'echo strtotime("2007-02-13 13:23:00")."
";'
1171394580

so I need to run:

UPDATE phpgw_cal
SET datetime = datetime - (60*60)
WHERE mdatetime <= 1171394580 AND
datetime >= 1171394580 AND datetime <= 1175410800

UPDATE phpgw_cal
SET edatetime = edatetime - (60*60)
WHERE mdatetime <= 1171394580 AND
edatetime >= 1171394580 AND edatetime <= 1175410800

and then the dates will be shown properly?  just wanted to get verification 
before I run the command.




Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org