Displaying 1 result from an estimated 1 matches for "lqry".
Did you mean:
lbry
2004 Mar 10
2
Inserting Date Field into Oracle table using ROracle
...Version 0.53
> > drv <- dbDriver("Oracle")
> > con <- dbConnect( drv, "user/passwd")
> >
> > d <- data.frame( cbind( CDATE="TO_DATE('02-02-2004
> > 10:12:00','DD-MM-YYYY HH:MI:SS' )" ) )
> >
> > lQry <- "INSERT into DATEST (CDATE) VALUES ( :1 ) "
> >
> > ps <- dbPrepareStatement(con, "INSERT into DATEST
> (CDATE) VALUES (
> > :1 ) ",
> > bind=c( "character")) ## --------- c("date")
> > gives error shown below...