HI, thinks .
Can you describe it clearer? Local server(linux) timezone is correct. ZONE="Asia/Shanghai" [email protected] From: Josh Elser Date: 2017-08-16 10:52 To: dev Subject: Re: date function error 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] >
