[R] create variable

[Bert Gunter]

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 <sewashm at 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 at 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.