[ https://issues.apache.org/jira/browse/DRILL-4721?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bridget Bevens resolved DRILL-4721. ----------------------------------- Resolution: Fixed Reviewer: Vitalii Diravka Fix Version/s: 1.15.0 Documented the date_diff function. > 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 > Fix For: 1.15.0 > > > 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 <brum...@maprtech.com> > Date: Thu, Aug 20, 2015 at 11:56 AM > Subject: Re: [mapr-tech-qa:12242] "dateDiff" in Drill > To: "mapr-tech...@maprtech.com" <mapr-tech...@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 <tdunn...@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 (v7.6.3#76005)