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]