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

[Jim Valavanis]

cw wrote on Tue, 13 March 2007 08:56
> On 3/13/07, Jim Valavanis wrote:
> > I ran the script to move the calendar times back an hour, it actually 
> > flip-flopped the start/end times.  So all entries that were from 
> > 9:00am-10:00am  move to 9:00am-8:00am  (which obviously worked, as far as 
> > changing the times back an hour, but flip-flopped the start/end times.  
> > Maybe a quick way to fix this?
> 
> >did you copy/paste the sql or retype it and maybe misplaced an "e"?
> reviewing it I don't see a way for this to flip-flop.
> 
> I typed it in, and made sure it was correct:  Here I'll paste the mysql 
> history...
> 
> UPDATE phpgw_cal set datetime = datetime - (60*60) WHERE mdatetime >= 
> 1173600000 AND datetime <= 1175410800;
> 
> and...
> UPDATE phpgw_cal set edatetime = edatetime - (60*60) WHERE mdatetime <= 
> 1173600000 AND edatetime >= 1173600000 AND edatetime <= 1175410800;
> 
> Jim
> _______________________________________________
> phpGroupWare-users mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-users

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