You solved your date column problem?
You should make a table with a date column.
Instead of adjusting the date setting for this session, you can use the
format function of R to adjust the string you are feeding to your db?
Bart
--
View this message in context:
http://n4.nabble.com/sqlUpdate-ROD
Update - The first problem is solved:
sqlQuery(channel, "create table TEST3 (NR NUMBER, NAME VARCHAR2(55),TAG
DATE)")
--
View this message in context:
http://n4.nabble.com/sqlUpdate-RODBC-tp1460867p1460899.html
Sent from the R help mailing list archive at Nabble.com.
_
Dear all,
I using R version 2.9.0 on Windows XP and want to insert data from a data
frame in R into a oracle database via sqlUpdate with the package RODBC.
My example is the following:
TEST0<-data.frame(NR=c(1,2,600),NAME=c("JK","TR","AR"),
DATUM=c("2009-01-01","2010-01-02","2010-06-09"))
If I
3 matches
Mail list logo
