In Calcite you can do (currentdate - cal_date) DAYS
which returns an INTERVAL DAYS value. In https://issues.apache.org/jira/browse/CALCITE-1124 we added TIMESTAMPADD, TIMESTAMPDIFF. DATEDIFF is mentioned in https://issues.apache.org/jira/browse/CALCITE-759 but that has not been implemented. Julian On Fri, Jun 10, 2016 at 7:54 AM, ShaoFeng Shi <[email protected]> wrote: > I don't see such a function in Calcite (Kylin's SQL parser): > https://calcite.apache.org/docs/reference.html#datetime-functions > > > 2016-06-10 10:04 GMT+08:00 Uma Maheshwar Kamuni <[email protected]>: > >> i want make DateDiff between currentdate and cal_date (which contains date) >> >> ________________________________ >> From: ShaoFeng Shi <[email protected]> >> Sent: Thursday, June 9, 2016 8:22:08 PM >> To: [email protected] >> Subject: Re: How to do DateDiff in Kylin >> >> Hi Uma, could you please give a sample SQL with DateDiff? >> >> 2016-06-09 13:49 GMT+08:00 Uma Maheshwar Kamuni <[email protected]>: >> >> > is there any function for DateDiff in Kylin. >> > >> >> >> >> -- >> Best regards, >> >> Shaofeng Shi >> > > > > -- > Best regards, > > Shaofeng Shi
