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 <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 (v6.3.4#6332)