Bridget Bevens created DRILL-4721:
-------------------------------------
Summary: Doc "dateDiff" in Drill
Key: DRILL-4721
URL: https://issues.apache.org/jira/browse/DRILL-4721
Project: Apache Drill
Issue Type: Task
Components: Documentation
Reporter: Bridget Bevens
Assignee: Bridget Bevens
Priority: Minor
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 <[email protected]>
Date: Thu, Aug 20, 2015 at 11:56 AM
Subject: Re: [mapr-tech-qa:12242] "dateDiff" in Drill
To: "[email protected]" <[email protected]>
Yes, it should be. We can fix that.
Bob
On Thu, Aug 20, 2015 at 11:46 AM, Joseph Blue <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
