Yes, it's more like that, to limit the amout of data imported in R from Oracle.
- Mail original -
De: "Jeff Newmiller"
À: "Marc Schwartz" , "cindy.dol"
Cc: r-help@r-project.org
Envoyé: Vendredi 6 Juillet 2012 20:00:37
Objet: Re: [R] Compare date Orac
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 wit
2-06-12" "2012-06-13" "2012-06-14" "2012-06-27"
> class(date3[difft,] )
[1] "Date"
A.K.
- Original Message -
From: cindy.dol
To: r-help@r-project.org
Cc:
Sent: Friday, July 6, 2012 11:50 AM
Subject: [R] Compare date Oracle with Sys.time
"
now_7_new<-as.Date(Sys.time()-(7*60*60*24), format="%Y-%m-%d %H:%M:%S")
> now_7_new
[1] "2012-06-29"
> class(now_7_new)
[1] "Date"
A.K.
- Original Message -
From: cindy.dol
To: r-help@r-project.org
Cc:
Sent: Friday, July 6, 2012 11:50 AM
Sub
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
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-ti
6 matches
Mail list logo
