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:[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. Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org _______________________________________________ phpGroupWare-users mailing list phpGroupWare-users@gnu.org http://lists.gnu.org/mailman/listinfo/phpgroupware-users
