Yes, it's more like that, to limit the amout of data imported in R from Oracle.
----- Mail original ----- De: "Jeff Newmiller" <jdnew...@dcn.davis.ca.us> À: "Marc Schwartz" <marc_schwa...@me.com>, "cindy.dol" <cindy.dolom...@insa-lyon.fr> Cc: r-help@r-project.org Envoyé: Vendredi 6 Juillet 2012 20:00:37 Objet: Re: [R] Compare date Oracle with Sys.time Yes, this request is woefully incomplete, but it looked to me like the question was how to select the data so that a limited amount of data could be imported, rather than loading the whole table and subsetting in R. If so, the discussion should be about constructing appropriate SQL (with or without parameters), which seems out of scope for this list (perhaps R-sig-DB?). --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... Live: OO#.. Dead: OO#.. Playing Research Engineer (Solar/Batteries O.O#. #.O#. with /Software/Embedded Controllers) .OO#. .OO#. rocks...1k --------------------------------------------------------------------------- Sent from my phone. Please excuse my brevity. Marc Schwartz <marc_schwa...@me.com> wrote: > >On Jul 6, 2012, at 10:50 AM, cindy.dol wrote: > >> 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? > > >Huh? How are you getting the data from Oracle into R? > >Typically Oracle DATE/TIMESTAMP data types come over as ?POSIXct in R, >if using facilities such as RODBC, which means using a regular date >based comparison. > >Use: > > str(DF) > >where 'DF' is your data frame, to review the structure of it. > >If your data frame is called DF and your date/time column is called >MyDATE, you can use as.Date() to coerce both to ?Date class and then do >the subtraction with days as the unit of measurement: > > NewDF <- subset(DF, as.Date(Sys.time()) - as.Date(MyDATE) < 7) > >If for some reason, you are importing your data via another means into >R, then you can still use ?as.Date to coerce the column to a Date class >and use the above incantation. > >See ?subset for additional information on that function. > >Regards, > >Marc Schwartz > >______________________________________________ >R-help@r-project.org mailing list >https://stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide >http://www.R-project.org/posting-guide.html >and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.