I am using RODBC to collect data from an ODBC connection to an MS Access Database. Everything seems to be working well except datetimes between March 12, 2006 02:00 and 02:59 get moved one hour forward. This does not seem to be happening with Excel connecting to the same connection. March 12 seems a bit early for Daylight savings time. What am I doing wrong? R 2.5.0 Windows XP with the latest RODBC (I'm not sure how to get the versions of the packages in use) Thank you very much, deinst (R is a fantastic package.) [[alternative HTML version deleted]]
> I am using RODBC to collect data from an ODBC connection to an MS Access > Database. Everything seems to be working well except datetimes between > March 12, 2006 02:00 and 02:59 get moved one hour forward. This does not > seem to be happening with Excel connecting to the same connection. March 12 > seems a bit early for Daylight savings time. What am I doing wrong?In 2007, the US moved daylight savings to March 11 instead of the more traditional first weekend in April. It continues to November 4, a week later than before. Google "daylight savings 2007" for lots of background. Some MS programs did not make the switch until April 1, therefore my calendars doubled up continuing appointments.>From your experience, it looks like some programs are retroactively misapplyingthe change to 2006.
On 6/26/07, Richard M. Heiberger <rmh at temple.edu> wrote:> > I am using RODBC to collect data from an ODBC connection to an MS Access > > Database. Everything seems to be working well except datetimes between > > March 12, 2006 02:00 and 02:59 get moved one hour forward. This does not > > seem to be happening with Excel connecting to the same connection. March 12 > > seems a bit early for Daylight savings time. What am I doing wrong? > > In 2007, the US moved daylight savings to March 11 instead of the more traditional > first weekend in April. It continues to November 4, a week later than before. > Google "daylight savings 2007" for lots of background. > > Some MS programs did not make the switch until April 1, therefore my calendars > doubled up continuing appointments. > > From your experience, it looks like some programs are retroactively misapplying > the change to 2006. >Thanks, that seems to be the problem. Now I need to figure out how to fix it, but I know where to look.