I think you need to do some homework on your own first. Have you gone through any R tutorials? -- there are many good ones on the web. Including ones on date-time processing in R.
To answer your question directly, read up on date/time classes and functions with ?"date-time" . You may also find the "lubridate" package useful, as it is intended to standardize and simplify typical date-time processing and analysis. Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Sun, Oct 9, 2016 at 7:56 AM, Ashta <sewa...@gmail.com> wrote: > I am trying to query data from Hive service and create a variable. > > > dbGetQuery(hivecon,"select date1, date2 from dateTable limit 10") > date1, date2, Diif > 4/5/1999, 6/14/2000 > 7/2/1999, 6/26/2000 > 8/14/1999, 8/19/2000 > 11/10/1999, 9/18/2000 > 8/25/2000, 6/5/2001 > 3/14/2012, 3/15/2004 > > > Here is what I wanted to do. While I am querying I want create a > variable diff= dat1e1-date2. > I may use this variable "diff" to do some statistics (mean, mode, > etc) and also in the where clause l like as the following. > > test_date=dbGetQuery(hivecon,"select date1, date2 from dateTable > where diff gt 1000 limit 10") > > I would appreciate if you suggest me how to do this. > > > > Here is the sample of the data and result > > date1, date2, Diif > 4/5/1999, 6/14/2000, -436 > 7/2/1999, 6/26/2000, -360 > 8/14/1999, 8/19/2000, -371 > 11/10/1999, 9/18/2000, -313 > 8/25/2000, 6/5/2001, -284 > 3/14/2012, 3/15/2004, 2921 > > Thank you in advance > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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 -- To UNSUBSCRIBE and more, see 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.
