[jira] [Created] (DRILL-4721) Doc "dateDiff" in Drill

["Bridget Bevens (JIRA)" <ji...@apache.org>]

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 <br...@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" <ma...@maprtech.com>


Yes, it should be. We can fix that.

Bob

On Thu, Aug 20, 2015 at 11:46 AM, Joseph Blue <jb...@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 <td...@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 <jb...@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 <mb...@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 <jb...@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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)