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.
