[R] Strange RODBC problem

[David Einstein]

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.