Re: TIMESTAMPADD sql jdbc function execution in drill

lto:arina.yelchiy...@gmail.com > <mailto:arina.yelchiy...@gmail.com>] > Sent: 08 February 2016 PM 01:13 > To: dev@drill.apache.org <mailto:dev@drill.apache.org>; Sudip Mukherjee > Subject: Re: TIMESTAMPADD sql jdbc function execution in drill > > Hi Sudip, > > timestampad

RE: TIMESTAMPADD sql jdbc function execution in drill

Thanks a lot for the information. Regards, Sudip From: Arina Yelchiyeva [mailto:arina.yelchiy...@gmail.com] Sent: 08 February 2016 PM 01:13 To: dev@drill.apache.org; Sudip Mukherjee Subject: Re: TIMESTAMPADD sql jdbc function execution in drill Hi Sudip, timestampadd / timestampdiff functions

RE: TIMESTAMPADD sql jdbc function execution in drill

- From: Khurram Faraaz [mailto:kfar...@maprtech.com] Sent: 08 February 2016 PM 12:14 To: dev@drill.apache.org Subject: Re: TIMESTAMPADD sql jdbc function execution in drill I didn't find it on the documented date time functions here https://drill.apache.org/docs/date-time-functions

Re: TIMESTAMPADD sql jdbc function execution in drill

> Sudip > > -Original Message- > From: Khurram Faraaz [mailto:kfar...@maprtech.com] > Sent: 08 February 2016 PM 12:14 > To: dev@drill.apache.org > Subject: Re: TIMESTAMPADD sql jdbc function execution in drill > > I didn't find it on the documented date time functi

TIMESTAMPADD sql jdbc function execution in drill

Hi, Are TIMESTAMPADD / TIMESTAMPDIFF functions supported through drill? I am getting an error while running the below query SELECT CAST(EXTRACT(YEAR FROM CAST({fn TIMESTAMPADD(SQL_TSI_YEAR,CAST(`myshare`.`mtm` AS INTEGER),{d '1970-01-01'})} AS DATE)) AS INTEGER) AS

Re: TIMESTAMPADD sql jdbc function execution in drill

I didn't find it on the documented date time functions here https://drill.apache.org/docs/date-time-functions-and-arithmetic/ On Mon, Feb 8, 2016 at 12:09 PM, Sudip Mukherjee wrote: > Hi, > Are TIMESTAMPADD / TIMESTAMPDIFF functions supported through drill? I am >