date function error

[apache_...@163.com]

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 




apache_...@163.com