Hi,

This sounds like a timezone issue to me. Depending on how you wrote the date, conversion from GMT into your local timezone can appear to "change" a date.

Can you try setting the timeZone[1] parameter in the JDBC URL?

[1] https://calcite.apache.org/avatica/docs/client_reference.html#timeZone

On 8/15/17 10:24 PM, [email protected] wrote:
Hi,

when i run sql by kyline GUI,Right result is  2011-02-28,but i got  
2011-03-01,is bug?

select cast('2011-03-31' as date)  - INTERVAL '1' month from KYLIN_CAL_DT




[email protected]

Reply via email to