[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