[R] A problem importing a particular date from SQL Server
Carolina C. Castro
cccastro at x-project.com.ar
Fri May 7 22:31:28 CEST 2010
I'm importing a table from a database in SQL Server using the RODBC package
(function sqlQuery()). But I've encountered a problem and I can't figure
out the cause: in all records with date 1988-12-01 (yyyy-mm-dd) I receive an
NA in R (when the date is OK in the SQL database).
I tried changing the date to 1988-12-01, and it worked fine, but I can't
find the reason for transforming the first of december in NA, has anyone
found this before? Is there any reason for this? And should I check the
rest of the dates to see what happened (I took a sample and the rest were
I forgot, that field in the database has "datetime" format.
More information about the R-help