[R] RODBC and datetimes

Dave Mitchell dmmtchll at gmail.com
Thu Jan 31 23:20:02 CET 2013

I've got a data.frame I'm trying to insert into a database table in an
ms sql server instance using RODBC.   When I save a table using
nothing but character and numeric columns things work fine.  However,
when I attempt to add another column of type POSIXct to the data.frame
and redefine the table to incorporate the new column (in the
DB),attempting to push the table to the DB using sqlSave results in
the following error:

Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test,  :
  missing columns in 'data'

Has anyone successfully been able to insert into a datetime field in
ms sql server?  If so, what type of variable did you use in R?  I'm
not really sure where to go or what to try next here.  Any advice is
appreciated.  Thanks!

Dave Mitchell

More information about the R-help mailing list