[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[phpGroupWare-users] Re: Re: Daylight Savings Time Issue
From: |
Jim Valavanis |
Subject: |
[phpGroupWare-users] Re: Re: Daylight Savings Time Issue |
Date: |
Tue, 13 Mar 2007 09:35:29 -0700 (MST) |
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
- [phpGroupWare-users] Daylight Savings Time Issue, Jim Valavanis, 2007/03/12
- Re: [phpGroupWare-users] Daylight Savings Time Issue, Chris Weiss, 2007/03/12
- Re: [phpGroupWare-users] Daylight Savings Time Issue, Chris Weiss, 2007/03/12
- Re: [phpGroupWare-users] Daylight Savings Time Issue, Chris Weiss, 2007/03/12
- [phpGroupWare-users] Re: Daylight Savings Time Issue, Jim Valavanis, 2007/03/13
- Re: [phpGroupWare-users] Re: Daylight Savings Time Issue, Chris Weiss, 2007/03/13
- [phpGroupWare-users] Re: Re: Daylight Savings Time Issue,
Jim Valavanis <=
- [phpGroupWare-users] Re: Re: Daylight Savings Time Issue, adam williams, 2007/03/17
- Re: [phpGroupWare-users] Re: Re: Daylight Savings Time Issue, Chris Weiss, 2007/03/17
- [phpGroupWare-users] Re: Re: Re: Daylight Savings Time Issue, adam williams, 2007/03/17
- Re: [phpGroupWare-users] Re: Re: Re: Daylight Savings Time Issue, Chris Weiss, 2007/03/17
- [phpGroupWare-users] Re: Re: Re: Re: Daylight Savings Time Issue, adam williams, 2007/03/17
- Re: [phpGroupWare-users] Re: Re: Re: Re: Daylight Savings Time Issue, Chris Weiss, 2007/03/17
- [phpGroupWare-users] Re: Re: Re: Re: Re: Daylight Savings Time Issue, Jim Valavanis, 2007/03/17