phpgroupware-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Chris Weiss
Subject: Re: [phpGroupWare-users] Re: Re: Re: Daylight Savings Time Issue
Date: Sat, 17 Mar 2007 16:24:12 -0500

On 3/17/07, adam williams wrote:
[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.



only the values right after mdatetime should be changed, 1173600000 is
the start date of this years DST and should stay the same.




reply via email to

[Prev in Thread] Current Thread [Next in Thread]