Details
-
Task
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
Fwd: [mapr-tech-qa:12242]Doc "dateDiff" in Drill
Inbox
x
Neeraja Rentachintala
3:32 PM (19 minutes ago)
to me
we should document the datediff function. Cisco was asking about it today.
---------- Forwarded message ----------
From: Bob Rumsby <brumsby@maprtech.com>
Date: Thu, Aug 20, 2015 at 11:56 AM
Subject: Re: [mapr-tech-qa:12242] "dateDiff" in Drill
To: "mapr-tech-qa@maprtech.com" <mapr-tech-qa@maprtech.com>
Yes, it should be. We can fix that.
Bob
On Thu, Aug 20, 2015 at 11:46 AM, Joseph Blue <jblue@maprtech.com> wrote:
Seems as though functions like datediff should be here:
https://drill.apache.org/docs/date-time-functions-and-arithmetic/
On Thu, Aug 20, 2015 at 11:32 AM, Ted Dunning <tdunning@maprtech.com> wrote:
Joe
Do you have a suggestion for the docs? Perhaps a few cross links would make it better?
Sent from my iPhone
On Aug 20, 2015, at 5:36, Joseph Blue <jblue@maprtech.com> wrote:
OK, duh. Thanks for that. I just went down the wrong path in the documentation.
This obviously does exactly what I want.
On Wed, Aug 19, 2015 at 10:26 PM, Mehant Baid <mbaid@maprtech.com> wrote:
You can use the datediff function as follows:
select datediff(date '2008-2-23', date '2008-1-20') from cp.`employee.json` limit 1;
---------
| EXPR$0 |
---------
| 34 |
---------
Thanks
Mehant
On Wed, Aug 19, 2015 at 7:00 PM, Joseph Blue <jblue@maprtech.com> wrote:
Want to get the difference between two dates in Drill. I used the AGE function which produces an interval. But I want the answer in days, not months & days. Am I missing something from the documentation?
select age(cast('2015-01-01' as timestamp),cast('2014-11-30' as timestamp)) from sys.version;
---------
| EXPR$0 |
---------
| P1M2D |
---------
–
Joseph Blue
Data Scientist