[R] Strange RODBC problem
Richard M. Heiberger
rmh at temple.edu
Wed Jun 27 04:46:17 CEST 2007
> 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.
More information about the R-help
mailing list