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

Reply via email to