Hi Jun,

1.6 is quite an old version. I did a quick test in Apache Kylin 2.3.1 and the 
issue is no longer there.

[cid:2a57adc5-118c-42e7-8cf1-c58133ad32f8]

Thanks,
Silas

________________________________
发件人: jun <1063489...@qq.com>
发送时间: 2018年5月15日 15:56
收件人: dev@kylin.apache.org
主题: timestampadd has some error

kylin-1.6.0 version

1. SQL:  select part_dt, timestampadd(MONTH, 1, PART_DT) from KYLIN_SALES
result: 2012-01-01, 2012-01-01
MONTH result not correct;

2. SQL: select part_dt, timestampadd(DAY, 1, PART_DT) from KYLIN_SALES
result: 2012-01-01, 2012-01-02
DAY result corrcet

I found that DAY, HOUR, MINUTE correct, but MONTH and YEAR not work.

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Reply via email to