I am running R 2.1.1 in a Windows XP environment. I wish to use the sqlSave command to export a dataframe into Microsoft SQL.
My dataframe is called temp and has 2 columns, monthenddate and value. Monthenddate is in 'POSIXct', format. (i.e. 'POSIXct', format: chr "1984-01-31" "1984-01-31" "1984-01-31" "1984-01-31" ...). How can I export this dataframe into SQL and have the format in SQL by one of the standard SQL date formats? I am using the following r code: db <- odbcConnect("testserver") sqlSave(db, temp) ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html