Run : select date '2011-03-31' - INTERVAL '1' month from KYLIN_CAL_DT
got same result :2011-03-01 The result is incorrect [email protected] From: Alberto Ramón Date: 2017-08-15 16:21 To: dev Subject: Re: Leap Month calculate error Try to use DATE statement http://apache-kylin.74782.x6.nabble.com/about-kylin-sql-key-words-IN-td5908.html On 15 August 2017 at 08:59, [email protected] <[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] >
