On 3/17/07, adam williams wrote:
[mailto:[EMAIL PROTECTED] i586]# ls -l /etc/localtime
-rw-r--r-- 2 root root 3543 Feb 13 15:23 /etc/localtime
[mailto:[EMAIL PROTECTED] 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.
_______________________________________________
phpGroupWare-users mailing list
phpGroupWare-users@gnu.org
http://lists.gnu.org/mailman/listinfo/phpgroupware-users
