drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bridget Bevens (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4721) Doc "dateDiff" in Drill
Date Mon, 13 Jun 2016 22:54:03 GMT
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

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.


On Thu, Aug 20, 2015 at 11:46 AM, Joseph Blue <jblue@maprtech.com> wrote:
Seems as though functions like datediff should be here:

On Thu, Aug 20, 2015 at 11:32 AM, Ted Dunning <tdunning@maprtech.com> wrote:

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      |




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

This message was sent by Atlassian JIRA

View raw message