Hello,
Not quite understand about ur problem. Could you dput your data? The below should be general format to convert to class date now_7<-format(Sys.time()-(7*60*60*24), "%Y-%m-%d 00:00:00") > now_7 [1] "2012-06-29 00:00:00" > class(now_7) [1] "character" 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 <cindy.dolom...@insa-lyon.fr> To: r-help@r-project.org Cc: Sent: Friday, July 6, 2012 11:50 AM Subject: [R] Compare date Oracle with Sys.time 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. ______________________________________________ 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.
