[
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 <[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
(v7.6.3#76005)
