[R] Compare date Oracle with Sys.time

cindy.dol cindy.dolomieu at insa-lyon.fr
Fri Jul 6 17:50:58 CEST 2012

I would like to import only datas of my table where DATE>today-7days.
But my datas in Oracle are 'dates' and in R are 'characters'.
now_7<-format(Sys.time()-(7*60*60*24), "%Y-%m-%d 00:00:00")
How to do?

View this message in context: http://r.789695.n4.nabble.com/Compare-date-Oracle-with-Sys-time-tp4635624.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list